View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Choose last number in a column

One way:

=LOOKUP(100^10,A:A)

Biff

"Don" wrote in message
...
I have a formula where one of the components is the last number in a
column.
I need to know how to always call the last value in a column that will be
added to every day.
--
Don Rountree