The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 Forum for Origin C
 script for selecting rows based on some given numb
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

zango24

India
Posts

Posted - 01/29/2015 :  1:15:43 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. 8 and Service Release (Select Help-->About Origin):
Operating System: win.

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

jasonzhao

China
262 Posts

Posted - 01/29/2015 :  9:49:14 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello,

You can try the Worksheet Query for this problem.
please select Worksheet: Extract Worksheet Data... in Origin menu:
then,refer to graph below:




Best Regards
Jason
OriginLab Technical Service

Edited by - jasonzhao on 01/29/2015 10:02:33 PM
Go to Top of Page

zango24

India
Posts

Posted - 01/31/2015 :  03:27:49 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks Jason for your vivid and visual reply.

Cheers,
zan



quote:
Originally posted by jasonzhao

Hello,

You can try the Worksheet Query for this problem.
please select Worksheet: Extract Worksheet Data... in Origin menu:
then,refer to graph below:




Best Regards
Jason
OriginLab Technical Service

Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000