| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
jump rows
Hi. I have a simple formula that i want to drag, but if first formula reffers
to row one, the second formula i want to reffer to row 3. can anyone help me? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
jump rows
On Sun, 7 Mar 2010 03:37:01 -0800, Adrian_C
wrote: Hi. I have a simple formula that i want to drag, but if first formula reffers to row one, the second formula i want to reffer to row 3. can anyone help me? thanks Replace A1 with OFFSET(A1,ROW()-x,) in your formula where x is the number of the row where you have your first formula. When you copy this formula down the references will be A1, A3, A5, etc. Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
jump rows
Post a copy of the formula so we can see what we have to work with, and tell
us what cell the first formula is in. Also, how far down/over do you want to drag it? And are you dragging it down the sheet or across it? "Adrian_C" wrote: Hi. I have a simple formula that i want to drag, but if first formula reffers to row one, the second formula i want to reffer to row 3. can anyone help me? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Key to Jump to end of row | Excel Discussion (Misc queries) | |||
| Jump certain columns with tab | Excel Discussion (Misc queries) | |||
| I want to jump to different cells with tab | Excel Discussion (Misc queries) | |||
| Sometimes data will jump rows randomly. | Excel Discussion (Misc queries) | |||
| Validation 'Jump To' | Excel Worksheet Functions | |||
Linear Mode
