How can I find duplicates in Numbers?

Writer,

to fill the formula down enter the fomula in cell D2 like we just discussed. then hit the enter key or click the green check box to finshing editing the formula.

now select cell D2 (single click), copy

now select column D (by clicking the "D" at the top of the column), then hold the <command> key and click cell D (to unselect the header), paste

Success at last. Thank you for your patience!! I get it.

So grateful Wayne.

This worked for me. I didn't think I would be able to figure out how to run the script but it was easy. Thank you so so much!

(I used the script to identify duplicates in a 1500 record database. It would have taken me ages to sort and scroll through manually!)

Thanks for the feedback! As you've discovered running a script is really easy. (It's writing one that can get complicated.🙂)

SG

SG,

Sorry I am having issues running the script. I keep getting a "Select some non-blank cells and try again."

I am not sure what I am missing. Thank you for your help

- Damon

dluvisi wrote:

SG,

Sorry I am having issues running the script. I keep getting a "Select some non-blank cells and try again."

Hi Damon,

There are several scripts in this thread but I think you must mean Copy Distinct. I think what is happening is that you are trying to run the script without first selecting cells with values in a table. Select the cells first, then click the run button. Then click once in a destination cell and type command-v to paste.

A link to download the Service is here. Double-clicking the downloaded .workflow package and giving permission in System Preferences > Security & Privacy will install it in your Numbers > Services menu. To run it there, you first select the cells with values, select Copy Distinct from the Numbers > Services menu, click a destination cell once, and type command-v to paste.

SG

SG,

That worked beautifully thank you so much for the help!

SG,

It all worked, Thank you so much!!!

Hi Friend,

This script is working fatalistically with one active sheet.

Is it possible to have the script work on all sheets in one numbers file?

Thank you.

Not sure which script you are using and what you have in mind. Perhaps you could post more details about what you are trying to do.

SG

Thank you for getting back to me.

The script I am using is:

I am trying to find all duplicates from a numbers file.

See there are many sheets in this file. I can only select one sheet.

Is there a way to find duplicates from all the sheets in this one Numbers file?

Thank you.

Wow, I thought Numbers didn't have a macro language to go with it? How/where is that code executed? Where can one learn the syntax of the language? I am an old programmer. You know, Fortran at NASA and Ada for air traffic control systems. Then I became a manager and you know how that goes. Thanks in advance.

Grihfen wrote:

Is there a way to find duplicates from all the sheets in this one Numbers file?

I can't think of a specific use case where one would want to check every cell in every table in every sheet of the front document and flag it if its value is the same as any other cell in that whole document, but anyway this script will do that (it will take a while to run).

SG

tell application "Numbers"

tell front document

set vList to {}

repeat with s in sheets

repeat with t in s's tables

repeat with c in t's cells

if vList contains (c's value as text) then set c's text color to "red"

copy c's value as text to vList's end

end repeat

end repeat

end repeat

end tell

end tell

MD_Gene wrote:

Wow, I thought Numbers didn't have a macro language to go with it? How/where is that code executed?

It's AppleScript. One of the many, many online resources is here.

SG

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.