Delete non duplicated rows
 

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

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