COPY FORMULA DOWN A COLUMN

G

Guest

I want to copy a formula down a column but the cell reference needs to be
changing by more than one. ie. my formula in A1 is =B1, my formula in A2 is =
B11. So when I now copy the formula in Column A down I want my formula in A3
to = B21 but when I highlight A1 and A2 then drag down my formula in A3 is
=B3. Any help much appreciated.
 
G

Gord Dibben

=OFFSET($A$1,10*ROW()-10,0) entered in B1 and copied down.


Gord Dibben MS Excel MVP
 

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

Excel Copy COUNTIF while retaining reference 7
Copy a formula using Vlookup 2
copy formula 3
Referencing a cell even if its contents are moved moved/replaced 6
Continuous Invoice Nos. 3
Copy formulas 2
Copying cell formulas 1
Formula from a single cell to a merged cell 4

Top