copying non-sequential cell references

G

Guest

I've always wondered if this is popssible and it would
help greatly. I need to copy the contents of every
thirteenth cell in column A to consecutive cells in
column B, so A13 copies to B1, A26 to B2, and so on. Is
there a quick way to write the formula for the cells in
column B? It will take forever to write the formula for
each B cell (200 of them!) individually.

Many thanks

Gary
 
R

Ron de Bruin

Hi
=INDIRECT("A" & ROW()*13)
Click to expand...

ROW() give you the row number of the cell
The formula in B3 for example will display the value of

"A" & 3*13 = 39
A39
 

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

Copy addition formula of non-consecutive horizontal cells 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
Converting a number into a cell reference 2
custom data validation on cells with data validation values 2
Repeat formula for all cells in whole column 1
Problem with formula for finding last greater than/less than or equal to value 2
Count Non-Empty Cells In Each Row 0
get a cell reference as a result of an If Function 1

Top