I have a list of over 200 names which contains many duplicates. Im looking for the quickest way to sort these names into a list so that each only appears once. This will have to be done in an auto_open macro each time the file is opened. I'm looking for speed because this macro already does other stuff which takes up a bit of time. Any suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sorting unique fields in a list...
- Thread starter UKPhil
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
1. Turn on the macro recorder.
2. Select your list and choose Data, Filter, Advanced Filter from the menu.
3. Click Copy to another location, specify the location, click Unique records only and click OK.
4. Select the new list and choose Data Sort from the menu and click OK.
5. Turn off the macro recorder.
6. That code should get you started.
2. Select your list and choose Data, Filter, Advanced Filter from the menu.
3. Click Copy to another location, specify the location, click Unique records only and click OK.
4. Select the new list and choose Data Sort from the menu and click OK.
5. Turn off the macro recorder.
6. That code should get you started.
Upvote
0
Similar threads
- Solved
