Thread: In a column of numbers I need a function to find the last entry
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default In a column of numbers I need a function to find the last entry
=LOOKUP(2,1/(A1:A10<""),A1:A10)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Charlie Bamford" wrote in
message ...
For example I have a column that shows the running balance on a bank
account.
I want to find the latest balance which will be on the last populated row
of
the spreadsheet


Reply With QuoteReply With Quote