ExcelBanter - COPY FORMULA DOWN A COLUMN

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - COPY FORMULA DOWN A COLUMN (https://www.excelbanter.com/excel-discussion-misc-queries/157169-copy-formula-down-column.html)

Duncan

COPY FORMULA DOWN A COLUMN

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.

Gord Dibben

COPY FORMULA DOWN A COLUMN

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

Gord Dibben MS Excel MVP

On Wed, 5 Sep 2007 16:42:02 -0700, Duncan
wrote:

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.

Duncan

COPY FORMULA DOWN A COLUMN

Thanks - the sorts me out

All times are GMT +1. The time now is 09:25 PM.