Is there a formula for "last"

  • Thread starter Thread starter - Butch
  • Start date Start date
B

- Butch

I have a lookup cell that compares today's value with that of a week ago.
But sometimes (like on weekends) the today value doesn't change. Is there
a formula for "last"? i.e., instead of TODAY() is there a LAST()
formula?

Thanks. Butch
 
This formula will return the *last* numeric value entered in column A:

=LOOKUP(1E100,A:A)
 
Back
Top