| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminating repeats from a list
I am using Excel 2003. I am working with a list of names of various people,
in one column. I need to have this list reproduced on a blank worksheet with the repeated names removed. for instance, the list I'm working with would be something like: Pat Pat Dan Marie Marie Sharron Sharron Sharron Sharron Daniel Mark Mark Mark Mark ....and I would need this list to be reproduced on another tab as: Pat Dan Marie Sharron Daniel Mark Is there a way I can do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reducing a List by Eliminating Entries from Another List | Excel Discussion (Misc queries) | |||
| lookup values vertically in a list and return the repeats | Excel Worksheet Functions | |||
| Randomize list of integers beteen 1-x with no repeats | Excel Discussion (Misc queries) | |||
| How can I count the number of repeats in a list of data? | Excel Discussion (Misc queries) | |||
| How do I randomize a list without repeats | Excel Discussion (Misc queries) | |||
Threaded Mode
