-
All replies
-
Helpful answers
-
Mar 2, 2011 8:03 AM in response to Teaghueby Teaghue,Never mind! I found an old old post explaining that this can't be done in numbers, so I just did it in excel. -
Mar 2, 2011 9:06 AM in response to Teaghueby KOENIG Yvan,Teaghue wrote:
Never mind! I found an old old post explaining that this can't be done in numbers, so I just did it in excel.
Perfectly wrong !
The way to achieve the described goal was described several times in this forum.
*_You just didn't search carefully !_*
Searching for delet AND duplicate return several threads.
Here are two of them.
I didn't made a typo. I used delet so that it retrieve delete as well as deleting
http://discussions.apple.com/thread.jspa?messageID=12992492
http://discussions.apple.com/thread.jspa?messageID=11559125
Yvan KOENIG (VALLAURIS, France) mercredi 2 mars 2011 17:59:40 -
Jun 6, 2014 3:32 PM in response to KOENIG Yvanby kjordanca,The work-arounds require an awful lot of typing: create a function to decide if the row above or below is a duplicate, do some function cutting and pasting, followed by a sort and deleting the offenders. In my opinion, the original poster is correct; you can't do it easily in Numbers. If you want to do data analysis, don't use Numbers, it's so much easier in Excel, just three-clicks. Click the column, click data on the ribbon and select remove duplicates.
-
Jun 7, 2014 7:53 AM in response to kjordancaby SGIII,This is a very old thread!
As you say, it's very easy to do this in Excel. It is in Numbers too!
Just use this Copy Distinct Automator Service (Dropbox download).
Double-click the .workflow package to install in your Numbers > Services menu ( you may need to click 'Open Anyway' in System Preferences > Secrity and Privacy.).
To use, all you need to do is select the cells with the data, choose Numbers > Services > Copy Distinct, click once in a destination cell, and command-v to paste.
SG
-
-