File Exchange
Try Origin for Free
The Origin Forum
Home
|
Profile
|
Register
|
Active Topics
|
Members
|
Search
|
FAQ
|
Send File to Tech support
All Forums
Origin Forum
Origin Forum
Subtract values in neighboring rows of worksheet
Note:
You must be registered in order to post a reply.
To register,
click here
. Registration is FREE!
Screensize:
640 x 480
800 x 600
1024 x 768
1280 x 1024
UserName:
Password:
Anti-Spam Code:
Format Mode:
Basic
Help
Prompt
Format:
Font
Andale Mono
Arial
Arial Black
Book Antiqua
Century Gothic
Comic Sans MS
Courier New
Georgia
Impact
Lucida Console
Script MT Bold
Stencil
Tahoma
Times New Roman
Trebuchet MS
Verdana
Size
1
2
3
4
5
6
Color
Black
Red
Yellow
Pink
Green
Orange
Purple
Blue
Beige
Brown
Teal
Navy
Maroon
LimeGreen
Message:
* HTML is OFF
*
Forum Code
is ON
Smilies
[quote][i]Originally posted by vlnew[/i] [br]Hi all, I wonder whether there is a simple solution, which allows to do the following task in Origin: I have a worksheet with numbers, say A1 B1 C1 A2 B2 C2 A3 B3 C3 ... I want to extract from this worksheet only rows which satisfy the criteria A(i) - A(i-1) = 100. I know it's not complicated to program as a script, but is there some pre-existing script or command to do this in Origin? Thank you! [/quote]
Check here to include your profile signature.
Check here to subscribe to this topic.
T O P I C R E V I E W
vlnew
Posted - 11/17/2021 : 4:58:57 PM
Hi all,
I wonder whether there is a simple solution, which allows to do the following task in Origin:
I have a worksheet with numbers, say
A1 B1 C1
A2 B2 C2
A3 B3 C3
...
I want to extract from this worksheet only rows which satisfy the criteria A(i) - A(i-1) = 100.
I know it's not complicated to program as a script, but is there some pre-existing script or command to do this in Origin?
Thank you!
2 L A T E S T R E P L I E S (Newest First)
vlnew
Posted - 11/17/2021 : 6:35:26 PM
Excellent, thank you!
cpyang
Posted - 11/17/2021 : 6:32:28 PM
From Worksheet menu
Worksheet > Worksheet Query
CP
The Origin Forum
© 2020 Originlab Corporation
Snitz Forums 2000