Duplicate Entries on Numbers Spreadsheet

I am looking for a way to delete all duplicate entries on a numbers sheet.

MacBook Pro (M3, 2023)

Posted on Jul 22, 2024 8:03 AM

Top-ranking reply

Yellowbox

Level 7

21,981 points

Posted on Jul 23, 2024 3:41 AM

Hi Luis,

Perhaps this will work for you.

COUNTIF(B$2:B2,B2)

Fill down.

Delete rows where C is greater than 1. Sorting the table by Column C will make the delete rows easier.

Regards,

Ian.

View in context

Similar questions

Removing multiple row entries in Numbers I am trying to help my 94 year father in law organise a large spreadsheet into smaller ones. When cutting and pasting from one to the other I have ended up with some rows duplicated. I need to work out a simple way of removing large number of duplicate rows as trying to do this one by one is too time consuming. Any help/advise welcome. The information relates to post boxes so each row starts with a unique number followed by columns containing other information relating to that box. [Re-Titled by Moderator]
383 1
Numbers: Deleting rows in Sort results in deletion of rows not included in the Sort I have a spreadsheet of over 3,000 rows. I am cleaning up the data, using Sort. For example, I Sort the table for all cells with "PDF" in them. I delete all the rows. Later, I find that along with those rows I deleted, some rows not included in the Sort were also deleted. For example, if the Sort shows me Rows 1, 5, 6, 7, 9, 11, 15 & 21, and I highlight them and Delete them, later I find that Rows between them also were deleted (Rows 2, 3, 4, 8, 10, 12, 13, 14, 16, 17, 18, 19 & 20. Has anyone else noticed this oddity? I'm running Sonoma 14.6.1 and Numbers 14.3 Thanks.
259 2
Numbers double vision How please do I undo Duplicate Selection which has caused numbers spreadsheet to superimpose complete slightly offset text & figures on existing ditto. "Undo" option on drop down menu greyed out & not available.
641 3

2 replies

Top-ranking reply

Yellowbox

Level 7

21,981 points

Jul 23, 2024 3:41 AM in response to LuisUrueta

Hi Luis,

Perhaps this will work for you.

COUNTIF(B$2:B2,B2)

Fill down.

Delete rows where C is greater than 1. Sorting the table by Column C will make the delete rows easier.

Regards,

Ian.

SGIII

Level 8

37,604 points

Jul 24, 2024 10:58 AM in response to LuisUrueta

If you're lazy like me and don't like to enter and debug formulas in an extra column unless you have to, then you can get your list of distinct (de-duplicated) values with a few clicks. Just use a Pivot Table.

Click the original table, in the menu choose Organize > Create Pivot Table > On Current Sheet and drag the fields in the Pivot Options pane as shown.

You can copy-paste the resulting "de-duplicated" values wherever you need them.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Duplicate Entries on Numbers Spreadsheet