Delete non duplicated rows

A B
date/time data

I want to keep all the duplicates in B and delete the non duplicates. TIA

Check out the conditional formatting section. This section helps to find
duplicates, but you could change the formula to =1 instead of >1 to get the
non-duplicates.

http://www.ozgrid.com/Excel/Formulas.htm#CONDFORM

"cape" wrote:

>
> A B
> date/time data
>
> I want to keep all the duplicates in B and delete the non duplicates.
> TIA
>
>
> --
> cape
> ------------------------------------------------------------------------
> cape's Profile: http://www.excelforum.com/member.php...fo&userid=6476
> View this thread: http://www.excelforum.com/showthread...hreadid=385395
>
>