Formula for reading latest date

[leswes14]

Hello everyone, I am in serious need of a formula in the next few hours. I have attached an excel form to show what I need. I need a formula in column G that will replicate "keep" and "delete" like it is shown in column C.

Rules are -
The formula needs to read the latest date in order to show "keep" for each ID in column E.
Each identifier will have two dates that are the same, both should be "keep", but only for the latest date.
If an identifier has one date, like LX4, it is a "keep".

Does anyone know of a formula like this???? Please help....thank you!!!!!

[FDibbins]

1st, your dates are not dates, they are text that just looks like a date. Fix this 1st by highlighting the entire date range, then select Text2Columns, click next/next/ select DMY from the date dropddown/finished

Then use this ARRAY formula, copied down...
=IF(B2=MAX(IF($A$2:$A$17=A2,$B$2:$B$17,"")),"Keep","Delete")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[leswes14]

That works!!!!! THANK YOU SOOO MUUUCCCHHHH!!!!

[FDibbins]

Happy to help and thanks for the feeback and kind words, always appreciated

For future reference, please take a moment to mark the thread as "solved" towards the top of the screen- it helps keep things neat and tidy lol. I will do it for you this time