Remove duplicates but keep the latest row

duplicates cleanup maxifs

Flag the newest row per name as keep and the older ones as dup, then filter.

The problem

A name appears several times and you want to keep only the latest row.

Sample data

A Name, C Date. The name in row 2 also appears in row 4 with a later date.

Formulas

Flag: =IF(C2=MAXIFS(C$2:C$5,A$2:A$5,""&A2),"keep","dup")   -> row 2 dup, row 4 keep
No MAXIFS: =COUNTIFS(A$2:A$5,""&A4,C$2:C$5,">"&C4)=0        -> TRUE (row 4)
Unique count: =ROWS(UNIQUE(A2:A5))                            -> 3

Filter the flag column on keep to finish. MAXIFS needs Excel 2019 or later.

Tested on sample data by the Cellwise checker (log CW-PL-20261018-40). AI-made: the text, voice and visuals are generated by AI.

Checked before publishing: a check.