View Single Post
  #1   Report Post  
Rebecca
 
Posts: n/a
Default collecting cell data from every 33rd row

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