Thread
:
How do I select the last entry in a sheet, to use in a formula?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
How do I select the last entry in a sheet, to use in a formula?
=INDEX(Sheet1!B:B,MATCH(9.99999999999999E+307,Shee t1!B:B))-Sheet1!B3
--
Regards,
Tom Ogilvy
"Rens Duijsens" <Rens
wrote in message
...
Hello,
I have a list of entry's that grows every day.
I want to know the substraction of the last entry in the list and the
first
entry.
The position of the first entry is known (b3).
The position of the last enty is increased every day.
How do I select th last entry?
How do I enter this in a formula?
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy