| T O P I C R E V I E W |
| nahuelv |
Posted - 06/21/2016 : 2:04:37 PM
Origin Ver. : 9.0 64 bits
Operating System:Windows 8
Hello dear members of the forum: I have a column with 64.000 numbers. So I want another column that has in the first row the sum between the elements 1 to 200, the second row the sum between the elements 201 to 400 and so on. Is it any fast way to do this??
Thank you |
| 1 L A T E S T R E P L I E S (Newest First) |
| Hideo Fujii |
Posted - 06/21/2016 : 2:51:30 PM
Hi nahuelv,
Origin has the following "Reduce Rows" function, but unfortunately it is available from Origin version 9.1.
1) Choose "Worksheet: Reduce Rows" menu with the options like:
Reduce Method = Reduce N rows with merged values
Merge Rows = 200
Merge by = Sum
In an older version like yours, you can try the following:
1) In Set Column Values tool, use the following formula (when your data is in col(1), and output goes to col(2).)
mod(i,200)==1?col(1)[i]:col(2)[i-1]+col(1)[i]
2) For the output column of 1), choose "Worksheet: Reduce Rows" menu with the following options:
Reduce Method = Reduce N rows, then skip M rows
Delete Rows = 199
Skip Rows = 1
Hope this helps.
--Hideo Fujii
OriginLab
|
|
|
