Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I sort duplicate text data in excel?
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? |
#2
|
|||
|
|||
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 ... "TinaScheu" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Excel data into semicolon delimited text file | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou. | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |