View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Check for duplicate items and delete them

In an adjacent column, enter this

=COUNTIF(A$2:A2,A2) where A2 is the first cell in the series you want to
check.
Copy this down as needed.
Use AutoFilter to remove all rows where the value is 1.
--
HTH,
Barb Reinhardt



"chanse44" wrote:

Anyone have a way to check for duplicate cells in multiple rows and
automatically delete them? Thanks!