Deleting Non-Duplicate Rows

  • Thread starter Thread starter BillW
  • Start date Start date
B

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. . .
 
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.
 
Back
Top