copying cells at a specific interval
 

Hello,
I have a row of 12 000 cells, but i want to use just every 4th cell, for
example:
A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
A11
A12
A13

form that row i need just need A1, A4, A8, A12
How can i copy every 4th cell into another row? Or whatever solution to the
problem you offer
could you help me with this?
Thanks

copying cells at a specific interval
 

could someone help me with this, please?

copying cells at a specific interval
 

in B1
=indirect("A"&row($A1)*4)

drag fill down the column

In your example, A1 is omitted - it is not every 4th cell.

--
Regards,
Tom Ogilvy


"ANton Petrov" wrote in message
...
could someone help me with this, please?