How to get Excel to keep only duplicates instead of remove them?

[Shawn]

Is this possible? There must be an easier way than sorting by name and they manually picking out the duplicates. I am going through a list of 10,000 entries.

Thank you.

 

[nickbits]

sort by name then make a new column that checks if the row above it is the same
something like
=IFF(B1=A1,"Same", "")
Then filter to only show rows with a value in that column.
Not sure if there is an easier way.

 

[Dulanic]

Why don't you do COUNTIF in another column then filter out all rows above 1? Then just delete the rows.

 

[nickbits]

COUNTIF seems like a better approach

 

[Gintaras]

http://lmgtfy.com/?q= How+to+get+Excel+to+keep+only+duplicates+instead+of+remove+them?

 

[Shawn]

countif worked. thanks.