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
Bookmarks