Hi,

I am hoping some one will help me.

In a source sheet I have three columns:
Column A - (contains) Client IDs
Column B - (contains) Dates
Column C - (contains) dollar amounts

The Client IDs, in some cases, are duplicate because some clients are showing up on different dates.

What I am trying to get is that, on a separate sheet I have just the Client IDs (all unique), I want the formula to lookup the Client ID in the source sheet check what is the LARGEST/MAX number (if the client happens to have multiple dollar values) for that Client ID and bring the corresponding date.

In addition to the above, I would also like to know if there's a way that if a Client ID duplicates because of two different dates however if the dollar amount for each of the two dates is identical then the formula should show the max date.

Any help will be greatly appreciated.