| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple: how to express this named-range reference?
Sigh, I'm drawing a blank....
E10:E30 evaluates to additional cash based on values in U10:U30. Ostensibly, E11 is U11-U10; similarly for E12:E30. I have named U10:U30 "Cash". So I want to write that formula in a form similar to: =Cash - offset(Cash,-1,0) Or so I thought. The OFFSET(...) expression is wrong. What is the correct expression for "the same row minus one in the named range Cash"? I am looking for a solution that is readable and self-documenting. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Named Range reference via single Cell | Excel Discussion (Misc queries) | |||
| named range, offset self-reference | Excel Discussion (Misc queries) | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Threaded Mode
