Thread
:
Vlookup return most recent date (value)
View Single Post
#
5
Posted to microsoft.public.excel.misc
Bernard Liengme[_2_]
external usenet poster
Posts: 563
Vlookup return most recent date (value)
Don:
MIN or MAX if he wants the most recent?
Bernard
"Don Guillett" wrote in message
...
This is an ARRAY formula that must be entered/edited using
ctrl+shift+enter
=MIN(IF(a6:a66="a",B6:B66))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"ryanholliday" wrote in message
...
Hello,
I have a set of data where Column A contains an personal ID# (001).
Column
B contains a timestamp. My table has multiple entries for each ID# and
different timestamps for each entry. I want to use a vlookup to find the
MOST RECENT timestamp for EACH ID. Any help would be greatly
appreciated.
Thanks,
Ryan
Reply With Quote
Bernard Liengme[_2_]
View Public Profile
Find all posts by Bernard Liengme[_2_]