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,