Log in

View Full Version : Solved: How to Search the Latest Date in a Worksheet


jammer6_9
05-02-2007, 03:53 PM
How can I lookup or vlookup or search the latest date in a worksheet?
Shazam
05-02-2007, 04:41 PM
How can I lookup or vlookup or search the latest date in a worksheet?


If your dates are in column A then try the MAX Function.


=MAX(A2:A100)


Hope it helps!
lucas
05-02-2007, 04:47 PM
Works in a larger range too....
=MAX(A1:B6)
jammer6_9
05-02-2007, 11:32 PM
Definitely Shazam that help....
LUCAS thats what I am looking for lookup "in a larger range...." :whistle:
Thanks to both of you...