| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Removing Duplicates
XL 2002 SP3, Win XP HE SP1
Follow up to: microsoft.public.excel.misc Hi, what is the BEST way to remove duplicate cells (phone numbers, email addresses, etc.) from a long list in Excel? The duplicates usually would be in 1 column (Column "A: for example) Tx. S |
|
#2
|
|||
|
|||
|
Select the column. Then Data Filter Advanced Filter check unique
records only. If you later want to restore the duplicates, you can. If you want to permanently delete the duplicates, copy the column elsewhere. -- Gary's Student "sat" wrote: XL 2002 SP3, Win XP HE SP1 Follow up to: microsoft.public.excel.misc Hi, what is the BEST way to remove duplicate cells (phone numbers, email addresses, etc.) from a long list in Excel? The duplicates usually would be in 1 column (Column "A: for example) Tx. S |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Duplicates | Excel Discussion (Misc queries) | |||
| help removing duplicates for mail merge | Excel Discussion (Misc queries) | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
| Finding Duplicates | Excel Worksheet Functions | |||
| removing duplicates testing in 2 coloms | Excel Worksheet Functions | |||
Hybrid Mode
