Q: How can I find duplicates in Numbers?
-
Mar 26, 2014 3:36 PMby writer_in_virginia,Thank you. Corrected that.
Here's what I see now...
This immediately computes a value for the D2 cell.
Now, when I go to select entire D row, I get either the computed value of that cell duped all the way down -- or only a D2 cell with the text code of the formula -- as in screenshot below. I must have done something else off.
-
Mar 26, 2014 3:45 PMby Wayne Contello,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
-
Dec 4, 2015 1:57 PMby SGIII,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
-
Mar 25, 2016 4:22 PMby Grihfen,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.
-
Mar 25, 2016 5:44 PMby MD_Gene,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.
-
Mar 25, 2016 6:28 PMby SGIII,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
