Remove duplicates for unsorted data

[prashantsd]

Hello,

I need a VBA code to remove the duplicate records for the unsorted data. I would like to retain the latest row with duplicate and remove the first one.
Here is the data how it looks:
1 AAIBH00 Retain
2 AAIBJ00 Retain
3 AAIBL00 Retain
4 PCADM00 Remove
5 PCAGV00 Remove
6 AAJNV00 Retain
7 AAJOS00 Retain
8 AAJOU00 Retain
9 PCADM00 Retain
10 PCAGV00 Retain
I want the rows 4 an 5 to be removed as it has duplicate record in 9 and 10. This has to happen without sorting any data or using unique filters.
Let me know for the code to do this.

[arlu1201]

Why dont you want to sort the rows?

[[email protected]]

Hi,
below loop will do...???

Please Login or Register  to view this content.