| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
as i drag a cell, can increment the cell number? . eg.. D1..D4..D7
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
as i drag a cell, can increment the cell number? . eg.. D1..D4..D7
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
as i drag a cell, can increment the cell number? . eg.. D1..D4..D7
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "surfermike" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
as i drag a cell, can increment the cell number? . eg.. D1..D4
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
as i drag a cell, can increment the cell number? . eg.. D1..D4
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
as i drag a cell, can increment the cell number? . eg.. D1..D4
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 - |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
as i drag a cell, can increment the cell number? . eg.. D1..D4
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. "RagDyer" wrote: 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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot increment numbers on Ctrl+ drag the cells. | Excel Discussion (Misc queries) | |||
| How do I turn off auto increment when trying to drag and drop | Excel Discussion (Misc queries) | |||
| Increment column on drag down | Excel Discussion (Misc queries) | |||
| Increment a number in a cell for each page printed | Excel Discussion (Misc queries) | |||
| number cell increment +1 when dragging down box | Excel Worksheet Functions | |||
Linear Mode
