Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I delete duplicates in Numbers 2019

Hi! I have been looking into this issue for a few days now, decided this was the BEST wya to go. How do I delete duplicates inside Apples Numbers application on my iMac?


I have imported a list on information a few different times as some of the items have repeated information. How can I "filter" or automatically have the program filter the duplicate so I can mass delete them?


Thanks in advance!

iMac 21.5" 4K, macOS 10.14

Posted on Apr 1, 2019 8:33 AM

Reply
Question marked as Apple recommended

If your list is in a single column, the process is pretty easy.


Add a column to the table containing the list. For the example, I'll assume the list is in column A, the added column is column B, and that the table has one header row.


Click cell B2 to select it, then type = to open the formula editor, and enter the formula below:


COUNTIF(A$2:A2,A2)


Click the green checkmark on the editor to confirm the formula and close the editor. You should see the result, 1 in the cell.


Fill down.

Place the mouse pointer near the bottom edge of cell B2. When the Fill Handle (small yellow circle) appears, place the tip of the pointer on it, Click and hold, and drag down the column to fill the formula into all cells of column B.


Sort:

Select column B, then click the small v that appears when you place the pointer near the right end of the column reference tab, and choose Sort ascending to sort the table by the counts done by the formula.

Select and delete the rows containing a count greater than 1.


Regards,

Barry







Posted on Apr 1, 2019 10:28 AM

1 reply
Question marked as Apple recommended

Apr 1, 2019 10:28 AM in response to idfiMartin

If your list is in a single column, the process is pretty easy.


Add a column to the table containing the list. For the example, I'll assume the list is in column A, the added column is column B, and that the table has one header row.


Click cell B2 to select it, then type = to open the formula editor, and enter the formula below:


COUNTIF(A$2:A2,A2)


Click the green checkmark on the editor to confirm the formula and close the editor. You should see the result, 1 in the cell.


Fill down.

Place the mouse pointer near the bottom edge of cell B2. When the Fill Handle (small yellow circle) appears, place the tip of the pointer on it, Click and hold, and drag down the column to fill the formula into all cells of column B.


Sort:

Select column B, then click the small v that appears when you place the pointer near the right end of the column reference tab, and choose Sort ascending to sort the table by the counts done by the formula.

Select and delete the rows containing a count greater than 1.


Regards,

Barry







How do I delete duplicates in Numbers 2019

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.