Alrighty, I’m working on some homespun financial rejiggering. I have a manually-entered “Keyword” column that features many repeated values.
A small sampling:
- Cleaners
- Cleaners
- Cleaners
- Cell
- Cell
- Cell
- Cell
- Cell
- Cable
- Cable
- Cable
- Cable
- Band
- Band
- ATM Fee
- ATM Fee
- ATM Fee
- ATM Fee
- ATM Fee
- ATM Fee
- Amazon
- Amazon
- Amazon
- Amazon
- Amazon
- Amazon
- Amazon
I need to create either another column OR table that takes these many values, de-dupes them and sorts them alphabetically, like this:
- Cleaners
- Cell
- Cable
- Band
- ATM Fee
- Amazon
This needs to be done with formula… not manually or scripted.
Suggestions??
Best Answer
This AppleScript uses terms from the AppleScript Toolbox plug-in to function correctly.
I copied your list of duplicates and pasted them between the double quotes in the first line of my code
Will return A new list without the duplicates and copy it to your clipboard: