| Author |
 Topic  |
|
|
Iskandar
USA
Posts |
 Posted - 06/22/2005 : 2:59:32 PM
|
Hi everybody,
I need to extract every 10th row from the origin data worksheet, and could not get the right formula in a dialog box
Analysis=>Extract Worksheet Data
If anyone could help me, I would greatly appreciate.
Origin Version (Select Help-->About Origin): Origin 7.5
Operating System: Windows XP |
|
|
Mike Buess
USA
3037 Posts |
Posted - 06/22/2005 : 3:13:33 PM
|
Use the mod() function like this
Extract rows 1,11,21,...
if: mod(i,10)==1
Extact rows 2,12,22,...
if: mod(i,10)==2
Extract rows 10,20,30,...
if: mod(i,10)==0
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 06/22/2005 3:14:16 PM |
 |
|
|
Iskandar
USA
Posts |
Posted - 06/22/2005 : 3:19:29 PM
|
| It works! Thanks a lot! |
|
|
| |
Topic |
|
|
|
Extract Data from Worksheet