| T O P I C R E V I E W |
| Iskandar |
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 |
| 2 L A T E S T R E P L I E S (Newest First) |
| Iskandar |
Posted - 06/22/2005 : 3:19:29 PM
It works! Thanks a lot! |
| Mike Buess |
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 |
|
|
