Delete Unique Records in Excel?
I find it impossible to do the following in Excel.
I have a list of items as follows:
A
A
B
C
C
D
I would like to leave only those items in the list that are listed more than once. So the desired end result would be:
A
A
C
C
From this list, I could then easily delete the duplicates, which would leave:
A
C
Background: I have three [...]