Lookups(?) and duplicate indicators

[Jstrodder]

I have two columns of data (unfortunately, I'm not able to post the excel data format properly here for some reason). Column A is the identifier and column B is the date. I'm attempting to pull the last date in Column B for each individual number in Column A. For example, 048d34182e34581d9d2ba2ce31772ce5 would return 11/4/2014. Thanks for your help!


03abda41126cd5c19a976eae514804a1 2/4/2015
03abda41126cd5c19a976eae514804a1 2/4/2015
03abda41126cd5c19a976eae514804a1 2/4/2015
03ec92329d9e456433ef225be9c2be1d 7/14/2014
04035e31996c7c5ecfdae2626c2588a9 1/30/2015
048d34182e34581d9d2ba2ce31772ce5 7/23/2014
048d34182e34581d9d2ba2ce31772ce5 7/23/2014
048d34182e34581d9d2ba2ce31772ce5 7/24/2014
048d34182e34581d9d2ba2ce31772ce5 7/24/2014
048d34182e34581d9d2ba2ce31772ce5 11/3/2014
048d34182e34581d9d2ba2ce31772ce5 11/4/2014

 

[steve the fish]

You could try this in C1. Would return max (latest) date for each hash. You can then use vlookup or whatever you need to do. Enter CNTL-SHIFT-ENTER

=MAX(IF($A$1:$A$11=A1,$B$1:$B$11))