How can I lookup or vlookup or search the latest date in a worksheet?
How can I lookup or vlookup or search the latest date in a worksheet?
T-ogether
E-veryone
A-chieves
M-ore
One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.
Originally Posted by jammer6_9
If your dates are in column A then try the MAX Function.
=MAX(A2:A100)
Hope it helps!
SHAZAM!
Works in a larger range too....
=MAX(A1:B6)
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Definitely Shazam that help....
LUCAS thats what I am looking for lookup "in a larger range...."
Thanks to both of you...
T-ogether
E-veryone
A-chieves
M-ore
One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.