Delete duplicate entries

As the following includes deleting part of the contents of the list/table, I would strongly encourage making a Copy of the document/Table, and using that copy for the following procedure.

If the duplicate entries can be identified by the values in a single column, you could:

Add a column to the table to contain the following formula. (I've assumed the identifying value is in column C, and that there is a label in the first row of each column that is not repeated in the rest of the column.)

COUNTIF(C$1:C2,C2)

Fill the formula down to the end of its column (the count column)

Select the count column, then press command-C to Copy the formulas and their results.

With the column still selected, go to the Edit menu and choose Paste Formula Results.

This action replaces each copy of the formula with the result of its count in that row.

SORT the table ;ascending' on the values in the count column.

All of the duplicate rows will now be in the lower part of the table, in the rows where the count column contains any number larger than 1

An alternate method:

Several versions ago, SGIII wrote an Applescript/Automater service for removing duplicate entries from a Numbers table.

I suspect he has updated that service as needed, and, if so, will say so within a short time. You may want to wait for that solution to arrive.

Regards,

Barry

You could use also Filter, will work with current Numbers version.

AA and CC are duplicates.

With the Filter Cell you can find them and in a second step delete them.

Ralf