One way ..
Assuming data in col D, D10 down
Put in any starting cell, say, in E10:
=OFFSET($D$10,ROWS($A$1:A1)*33-33,)
Copy E10 down E71 thereabouts to complete the extract for 2000 rows
(until zeros appear, signalling exhaustion of data extract)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Rebecca" wrote in message
...
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)?
|