try this one:

=OFFSET($D$2,(ROW()-ROW($D$2))*33,)

Regards,
KL


"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)?