Delete non duplicated rows

[cape]

A B
date/time data

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

 

[Barb R.]

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