jjfrosty1

Q: How can I find duplicates in Numbers?

How can I find duplicates in Numbers?

Do I search each field or is there a short cut?

iMac (21.5-inch Mid 2011), OS X Mountain Lion (10.8.4)

Posted on Jul 19, 2013 9:47 AM

Close

Q: How can I find duplicates in Numbers?

  • All replies
  • Helpful answers

first Previous Page 5 of 5
  • by PonsAsinorum,

    PonsAsinorum PonsAsinorum Sep 22, 2016 8:43 AM in response to SGIII
    Level 1 (8 points)
    Sep 22, 2016 8:43 AM in response to SGIII

    First let me say, this script is wonderful and has saved me countless hours over the last year or so. Thank you so much for sharing it!

     

    However, Sierra seems to have broken it--at least for me--and I've had no luck debugging, (probably time I learn to  AppleScript properly). As best as I can tell, it runs the initial tell just fine, selecting the range I set, and gets that to the clipboard, but the deduplicate never occurs, so I end up with my original list.  Any help would be wonderful, and again thank you so much for all you do on this board.

  • by SGIII,

    SGIII SGIII Sep 22, 2016 8:52 AM in response to PonsAsinorum
    Level 6 (10,796 points)
    Mac OS X
    Sep 22, 2016 8:52 AM in response to PonsAsinorum

    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

  • by PonsAsinorum,

    PonsAsinorum PonsAsinorum Sep 22, 2016 9:16 AM in response to SGIII
    Level 1 (8 points)
    Sep 22, 2016 9:16 AM in response to SGIII

    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.

  • by PonsAsinorum,

    PonsAsinorum PonsAsinorum Sep 22, 2016 9:23 AM in response to SGIII
    Level 1 (8 points)
    Sep 22, 2016 9:23 AM in response to SGIII

    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!

  • by SGIII,

    SGIII SGIII Sep 22, 2016 9:32 AM in response to PonsAsinorum
    Level 6 (10,796 points)
    Mac OS X
    Sep 22, 2016 9:32 AM in response to PonsAsinorum

    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

first Previous Page 5 of 5