Good day,

Looking for some strategy - being a relatively inexperienced Excel user. I am have three columns of data to work with. I need to be able to find the value in column A in column B and return the maximum value in column C where column A and column B match. For example:

100159308420 10015930840 00/00/00
100159308430 100159308420 2/21/2007
100159308440 100159308420 2/21/2007
100159308450 100159308420 2/28/2007
100159308460 100159308420 2/27/2007
100159308470 100159308420 2/28/2007

I need the potential column D in the above to return 2/28/2007. The complexity is introduced in this since I have 5 recurring instances of above - but in the same data, I may have other recurring instances. Some will not recur. So I need to be able to do a lookup and then return the maximum in only the recurring instances for each unique lookup.

Anyone have direction? I appreciate the guidance. Hope I made it clear.

Thanks
Adam