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


--
BillW
------------------------------------------------------------------------
BillW's Profile: http://www.excelforum.com/member.php...o&userid=27516
View this thread: http://www.excelforum.com/showthread...hreadid=470299

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.

BillW wrote:
>
> 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. . .
>
> --
> BillW
> ------------------------------------------------------------------------
> BillW's Profile: http://www.excelforum.com/member.php...o&userid=27516
> View this thread: http://www.excelforum.com/showthread...hreadid=470299

--

Dave Peterson