Excel Function Removing Even Duplicates

gatefire08

New member
Joined
Mar 18, 2014
Messages
2
Reaction score
0
Points
0
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
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Assuming data starts in Row2, in C2 enter helper formula:

=AND(A3<>A2,MOD(B2,2)=1)

copied down

Then apply AutoFilter (Data|Filter) to the 3 columns.

Filter column 3 for FALSE and delete those rows.

Remove Autofilter and delete column 3 for final list.
 

gatefire08

New member
Joined
Mar 18, 2014
Messages
2
Reaction score
0
Points
0
Thank you for your help! it works!

The data is actually lil bit trickier! Apply the same concept, Example below, I want to pull out A4, and C9 and delete the rest. Is it possible?

What if the data is


Column 1 Column 2
A 1
A 2
A 4
B 1
B 2
C 1
C 2
C 5
C 7
C 9
D 1
D 2
D 4
D 6
 
Top