Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How does one refer to the n-1 element of a named range?
If I have established a range called Beginning_Inventory, and I want to set
it equal to the previous period's Ending_Inventory, what do I have to do? (Clearly, one could use a relative reference, but there are other reasons for not doing so.) Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How does one refer to the n-1 element of a named range?
Hi!
How does one refer to the n-1 element of a named range? What is the "n-1" element? =INDEX(named_range,1,1) Refers to the top leftmost element, that is, row1 column1. Biff "Charles Hewitt" <Charles wrote in message ... If I have established a range called Beginning_Inventory, and I want to set it equal to the previous period's Ending_Inventory, what do I have to do? (Clearly, one could use a relative reference, but there are other reasons for not doing so.) Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How does one refer to the n-1 element of a named range?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in large named range | Excel Worksheet Functions | |||
Named range links to external workbook, help! | Charts and Charting in Excel | |||
Dynamic Named Range with blank cells | Excel Discussion (Misc queries) | |||
Paste a named range to another range in Excel | Excel Discussion (Misc queries) | |||
Address of named range | Excel Worksheet Functions |