View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charlie Bamford
 
Posts: n/a
Default In a column of numbers I need a function to find the last entr

Fantastic!
Thanks for your help

"Bob Phillips" wrote:

=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