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