Thread: How to combine identical entries with different dates to reflect the latest date

Hi Guys,

I've an excel spreadsheet that has thousands of names (speadsheet from HR Department).

This spreadsheet contains each individuals Leave Entitlement (Leave codes).
However, there are lots of duplicates as there are multiple updates on different dates.

I would want a formula to display the latest date with Leave Entitlement tag together.
I was thinking through using Vlookup with SUMPRODUCT but cant seem to achieve the result.

I've attached the spreadsheet for easier understanding of what I'm trying to say.

Thanks in advance for those who've rendered assistance!

Leave Grades.xls

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Put this formula in I2 -

IF(AND(C2=C3,H2<H3),0,1)

All the 0 need to be deleted. The cells containing 1 is what you need after the deletion.