How can I find duplicates in Numbers?

I don't have Sierra yet, so I can't test it. But perhaps in System Preferences > Security & Privacy > Privacy > Accessibility you need to put a check by Automator.app, or otherwise give permission?

With each successive OS release the security safeguards seem to be getting a little tighter, meaning the user has to go in and explicitly give permission for Automator and AppleScript to run.

SG

Ah, I feared that might be the case. I have actually been running it directly with Script Editor, rather than adding it to numbers (I do have Script Editor added/checked in Accessibility).

I decided to try testing it on some simpler/dummy lists, (just single numbers or letters), and it is removing the duplicates there. Anyway, thanks for the quick reply, going to keep trying to sort it out.

😊 Found the problem (hint, it was me haha). Somehow, some trailing spaces snuck into a bunch of the values I was trying to deduplicate, rendering them unique to the script. I removed all the spaces and all is now well. Sorry to bother/thanks again!

PonsAsinorum wrote:

😊Somehow, some trailing spaces snuck into a bunch of the values I was trying to deduplicate, rendering them unique to the script.

Ah, it's easy to have that happen! Glad things worked out.

SG

Thanks for such a clear and complete example. I've never worked with automator or apple scripts, and you've made it out to be so easy. As a programmer, I feel as though a lot of doors have been opened for simpler work flows.

Thanks for the nice feedback!

SG