| T O P I C R E V I E W |
| zango24 |
Posted - 01/29/2015 : 1:20:50 PM
Origin Ver. 8 and Service Release (Select Help-->About Origin):
Operating System: win7.
Hello,
I would like to know if we can select specific rows based on our given input number.
For example: If I have a column contain more than 500 rows containing random numbers from 0 to 8000. If I would like to select all the rows which have number higher than say 100. How to do that. There is no trend of occurrence of such numbers. They are random.
Any small worksheet script would be great.
Thanks in advance.
Zan |
| 4 L A T E S T R E P L I E S (Newest First) |
| zango24 |
Posted - 02/13/2015 : 2:03:54 PM
In connection with my earlier query, I would like to know following:
In one column I have several numbers some with positive values and some with negative values. The distribution of these numbers is totally random. Using worksheet query I would like to select say all those numbers which are lower than zero but only those numbers which come first and continuous.
E.g. Col(A) values are:
1
2
3
4
-5
-3
-7
-2
8
2
4
6
-6
-1
-7
8
2
using wks query if I will take Alias A<=0 it will select all the negative values. But I want to only select -5,-3,-7 and -2 only because they come first and are continuous.
Any suggestions?
Thanks
Zan |
| lkb0221 |
Posted - 01/30/2015 : 11:19:47 AM
And there is worksheet filter as well, btw |
| zango24 |
Posted - 01/29/2015 : 1:52:29 PM
Cool,
Thanks Snow. I never realized that the solution could be so easy.
Thank you so much for your prompt reply.
Zan |
| snowli |
Posted - 01/29/2015 : 1:43:24 PM
You can use Worksheet Query for this.
With worksheet active,
choose Worksheet: Extract Worksheet Data... menu
Left panel lists all columns.
Move the column which you want to define the condition with to the right panel.
--> An Alias will be given to that column.
Enter condition in If box.
Suppose A is the alias of the column. Enter the following condition in If box.
A>100
Click Test - Select if True
It should select all rows with A>100
We have improved this tool and it's called Worksheet Query now. It supports recalculation so if you extract data to other worksheet, and later the source data change, the extracted sheet will update as well. Also conditions are easier to write than before.
http://www.originlab.com/doc/Origin-Help/Wks-Query
Thanks, Snow |
