Remove duplicates and keep oldest entry

[Bond007]

Hello all,
I've been struggling with coding a macro the remove duplicates from my data set.
Been looking at this threat and almost got it figured out but no luck.
Link

Please Login or Register  to view this content.

My data has duplicates in column G. I want to remove them (the entire row)but keep the oldest one based on a Date field (Col F)
However, I want it to look for another column - Requestor # (Col E) before deleting.


So I could have the following situations:
(Table now showing up in correct format so see photo attached)

Chart.jpg

Col E COL F Col G
Requestor # Date Info
1234 01/31/14 1234
1234 02/01/14 1234
This would delete the 2nd row and keep the one date 01/31

Col E Col F Col G
Requestor # Date Info
1234 01/31/14 1234
4321 02/01/14 1234
Keep both since Col E is different


Any help is greatly appreciated

[Bond007]

I got it to sort properly for my report and based off of the 3 fields above.
However, it's deleting the older rather than the newest items

Looking into it some more but hopefully someone has some insights as well.