as i drag a cell, can increment the cell number? . eg.. D1..D4..D7

S

surfermike

i wish to copy a cell with a formula, but as i drag it down it only
increments by one

can i make it increment by 2 ? or 3? etc.
 
L

Luke M

Depends what you mean. You'll get better answers if you can post an example
of your formula.
One idea is simply to put in A2
=A1+2
and copy down.
 
P

Pete_UK

Use this:

=INDIRECT("'PRice List'!B"&142+(ROW(A1)-1)*3)

and then just copy it down.

Hope this helps.

Pete
 
R

RagDyer

Non-volatile approach:

=INDEX('Price List'!B:B,142+3*ROWS($1:1)-3)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Use this:

=INDIRECT("'PRice List'!B"&142+(ROW(A1)-1)*3)

and then just copy it down.

Hope this helps.

Pete
 
S

surfermike

Merry Christmas and happy new year...
This was great help, and has helped further my understanding. I have used it
to great effect, cheers

mike
P.S. not sure by non-volatile (does not dissppear?) approach, but this is
the code i have used.
 
Top