copying cells at a specific interval

G

Guest

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
 
T

Tom Ogilvy

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

drag fill down the column

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete ALL cells containing the same data 1
Remove specific cells in a column. 2
how to use an formula to transpose a list(left) to be like the right? 2
Which zones are touch given this range 2
Need macro that concatenates cells with text 7
Autofill cells in 1 column :code ?? 2
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Need to add values...maybe 13

Top