View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?