Check for duplicate items and delete them

  • Thread starter Thread starter chanse44
  • Start date Start date
C

chanse44

Anyone have a way to check for duplicate cells in multiple rows and
automatically delete them? Thanks!
 
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.
 
you can also use the advanced filter to automatically just show you the
unique records. it's under Data, Filter, Advanced filter. Highlight which
column you want to filter for unique records. Click the Unique records only
box to filter the duplicates then either paste the new set of data on the
same column or in a new column. I suggest you paste it on a new location so
you can verify if it really worked.
 
Thank you both so much but neither one of these worked, aagh!!!!
 
That technique has worked for lots and lots of people.

You may want to explain why it didn't work for you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates Deletion ? 2
how do i combine excel worksheets 1
Eliminate Duplicate Row 1
expand duplicate check to multiple columns 3
Duplicate Rows 2
Finding Duplicate Cell Entries 6
remove duplicates but retain one not delete both 4
locating and deleting duplicate cell entries 2

Back
Top