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

[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.

 

[T. Valko]

You'll have to show us the formula.

 

[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.

 

[surfermike]

AS i drag the cell down i want it to increment by 3 .. or whatever?

eg. i manually doing each one at moment..

='PRice List'!$B142

='PRice List'!$B145

You'll have to show us the formula.

='PRice List'!$B148

 

[surfermike]

AS i drag the cell down i want it to increment by 3 .. or whatever?

eg. i manually doing each one at moment..

='PRice List'!$B142

='PRice List'!$B145

 

[Pete_UK]

Use this:

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

and then just copy it down.

Hope this helps.

Pete

 

[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

 

[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.