Deleting Non-Duplicate Rows

[BillW]

Have done tihs is the past, but can't remember how:
Have a sheet with 9500+ rows. Column C contains a storage bin number.
Want to delete all rows that DO NOT have a duplicate (trying to resolve
items that have a duplicate bin number.) Have sorted the sheet on
Column C. THX. . .

 

[Dave Peterson]

You could use a helper column of formulas:

=countif(c:c,c1)
and drag down

The ones that evaluate to 1 are singletons.

Data|filter|autofilter to show the 1's and delete those visible rows.