| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I filter names in Excel to eliminate repeats?
I have a list like this:
John Doe John Doe Mike Martin Nancy Smith Nancy Smith Nancy Smith I want to get it like this: John Doe Mike Martin Nancy Smith John Doe Nancy Smith Nancy Smith |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I filter names in Excel to eliminate repeats?
Have a look at Menu DataFilterAdvanced filter (no dupes)
HTH -- AP "Scott" a écrit dans le message de news: ... I have a list like this: John Doe John Doe Mike Martin Nancy Smith Nancy Smith Nancy Smith I want to get it like this: John Doe Mike Martin Nancy Smith John Doe Nancy Smith Nancy Smith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
| how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
| Excel 2003 Filter Problem | Excel Discussion (Misc queries) | |||
| How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) | |||
Linear Mode
