Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I automatically remove duplicate data within a column?
Is there a way to automatically remove duplicated data within a column in
Excel? For example, I have a column of over 10000 rows. The cell contents are call numbers, many of them are duplicate and I'd like to remove them without sorting and manually removing them. |
#2
|
|||
|
|||
Chip Pearson has a means for doing this at
http://www.cpearson.com/excel/deleting.htm If it is just a single column, though, you can use DataFilterAdvanced Filter. Once there, select Copy to a new Location and Unique Records only. That will give you a list of unique values in your column - i.e., no duplicates "MECG" wrote: Is there a way to automatically remove duplicated data within a column in Excel? For example, I have a column of over 10000 rows. The cell contents are call numbers, many of them are duplicate and I'd like to remove them without sorting and manually removing them. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Need Way to Automatically Select Data | Excel Worksheet Functions | |||
Removing Duplicate Data | Excel Worksheet Functions | |||
Is there a way to automatically add columns as the data updates? | Excel Worksheet Functions | |||
I wish to automatically populate cells with list data when a item. | Excel Discussion (Misc queries) |