Thread: How to use autofilter to delete duplicate rows (2nd criteria) ?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mslady[_12_] Mslady[_12_] is offline
external usenet poster
  
Posts: 1
Default How to use autofilter to delete duplicate rows (2nd criteria) ?

Thanks Nigel, that works fine. :)

I am asking how to delete the entire row if column A has more than one
(duplicates). And keep one.

e.g If column A has more than one count like this:
6/20/2005
6/20/2005
6/20/2005 etc.

How to delete the rest and keep just one.

Looking for a way to do this via AUTOFILTER.
Thanks Nigel ;)


--
Mslady
------------------------------------------------------------------------
Mslady's Profile: http://www.excelforum.com/member.php...o&userid=27776
View this thread: http://www.excelforum.com/showthread...hreadid=480312

Reply With QuoteReply With Quote