A B
date/time data
I want to keep all the duplicates in B and delete the non duplicates. TIA
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks