| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamically display in Active Cell value from 2 rows above it
Does anyone know the formula to ALWAY display the value in the active cell
which is 2 rows above it? For example: Display in Active cell c13 the value in c11 (row13-2=row11). The problem comes if I were to insert 4 rows after c11 and insert more data. I would subsequently want to display in c17 (13+4) the value from c15 which is 2 rows above it. An absolute cell reference is not the same as saying a constant of 2 rows above the active cell? Any ideas to share?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically display in active cell the value x-rows above it? | Excel Discussion (Misc queries) | |||
| How to make a formula cell dynamically display | Excel Worksheet Functions | |||
| Display of Active Cell in MS Excel 2007 | Excel Discussion (Misc queries) | |||
| How to Add Rows From Active Cell with in a XLL Code | Excel Worksheet Functions | |||
| Dynamically chart active row | Charts and Charting in Excel | |||
Threaded Mode
