Find Max Date for each cell in a column

[Kouemaha]

Hi,
in the attached file i would like to replace the "YES" in column C by a formula
The formula will check for each "code" (column A) which is the date that is most recent (max), and assign "YES" next to it..
Any idea?
Thanks a lot!

[David Breitenbach]

enter in C2 and copy down.
=IF(MAX(IF((A2=$A$2:$A$10)*($B$2:$B$10),$B$2:$B$10))=B2,"YES","")

[Fluff13]

How about

Please Login or Register  to view this content.

[PaulSP8]

This should work;

Please Login or Register  to view this content.

You'll need to use "Shift, CTRL and Enter" to use it, it's an array formula - If done correctly you'll see "{" and "}" at the start and end of the formula - Don't try and enter these yourself

[alansidman]

An alternative solution if you have a lot of records and are looking for speed is to employ power query.

the attached demos your issue and a power query solution.

[Gregb11]

You'll need to use "Shift, CTRL and Enter" to use it, it's an array formula - If done correctly you'll see "{" and "}" at the start and end of the formula - Don't try and enter these yourself

Just FYI - the OP is on version 365. This is no longer needed in that version.

[PaulSP8]

Thanks Greg - I didn't know that.

I also forgot about MAXIFS as per Fluffs answer - Still getting used to some of these new fangled things LOL