remove unique entries?

[justincase]

I see there is a "remove duplicates" function that is extremely useful, however is there a "remove unique" equivalent? I have a huge table (about 24,000 rows) and I need to ONLY keep the ones that contain duplicates within the field in question. Any ideas?

[martindwilson]

id use something like in a new column
=IF(COUNTIF($A$1:$A$20,A1)>1,"","unique") dragged down adjust range to suit.copy/paste back special values then remove duplicates based on the word unique

[justincase]

worked like a charm! thanks a bunch!