How can I sort duplicate text data in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large list of noames that I need to make sure that none of them are
duplicated. Is there a way to have excel check it quisker than me reading
every name until I find a duplicate?
 
After selecting your data go to filter Advanced filter and check "Unique
records only"
You can even copy it to another area all uniques entries if you want to ...
 
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
Removing Duplicates to another sheet 1
Can I use a lookup on data containing duplicate entries? 2
Entire Row Duplicates 6
Identifying duplicate data 4
Finding Duplicates in a Column (Without Sorting) 3
Data Validation /w Duplicate Entries 3
How do I eliminate duplicae records in excel file 1

Back
Top