Excel Function Removing Even Duplicates

[gatefire08]

Hello,

I want to pull the very last odd duplicate. Example below, I want to pull out A3, and C5 and delete the rest. Is there a function that will allow me to do this? Thank you so much in advance!

For example,

Column 1 Column 2
A 1
A 2
A 3
B 1
B 2
C 1
C 2
C 3
C 4
C 5
D 1
D 2
D 3
D 4

[cbatrody]

Hi,

I have created a template by going through the description you have provided here. Please go through that and see if it suits your requirement.

All you need to do is filter column 'C' for "FALSE" & you get the last duplicate entries there. You can copy paste the filtered items into a new sheet if you like. Also, please do not forget to SORT column 'A' before you apply the filter.




Regards,
Chandra




Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.