COPY FORMULA DOWN A COLUMN

's Computer Specifications

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.

's Computer Specifications

=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 <(E-Mail Removed)>
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.

's Computer Specifications

Thanks - the sorts me out

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy a Formula from a Column to a Row	Jon	Microsoft Excel Misc	2	10th Sep 2008 12:04 AM
Formula won't copy down the column	Chip	Microsoft Excel Discussion	1	9th May 2008 07:30 PM
copy formula down a column and have cell references change within formula	brad	Microsoft Excel New Users	5	13th May 2007 04:38 PM
How do I copy a formula all the way down a column........	=?Utf-8?B?bHVjZG9s?=	Microsoft Excel Worksheet Functions	6	12th Feb 2007 12:23 AM
Copy a formula down a column	Otto Moehrbach	Microsoft Excel Worksheet Functions	3	13th Apr 2006 04:44 PM