Assuming the column whose data you want to summarize is A, and that your
summary starts in row 2, put this formula in row 2 and copy it down:
=OFFSET($A$10,(ROW()-2)*33,0)
If the summary is going to start in some row other than 2, change the
ROW()-2 so that it is ROW()-starting row #.
"Rebecca" wrote:
Could somebody please help me, I have a big file (over 2000 rows) in excel
and I would need to collect every 33rd cells in the same column one after
another to other column. It makes easier to handle data and draw charts...
Can i write a formula that would add 33 rows to previous cells formula ( like
=D10 +10 rows downwards so the next cell would be =D43)?
|