as i drag a cell, can increment the cell number? . eg.. D1..D4
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 !
---------------------------------------------------------------------------
"Pete_UK" wrote in message
...
Use this:
=INDIRECT("'PRice List'!B"&142+(ROW(A1)-1)*3)
and then just copy it down.
Hope this helps.
Pete
On Dec 15, 11:43 pm, surfermike
wrote:
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
"surfermike" wrote:
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
"T. Valko" wrote:
You'll have to show us the formula.
--
Biff
Microsoft Excel MVP
"surfermike" wrote in message
...
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.
='PRice List'!$B148- Hide quoted text -
- Show quoted text -
|