You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Shek8964 Author

Level 1

4 points

How to automatically find identicals in worksheet?

Let say I have a Numbers worksheet like this, how can I set to highlight the second row with identical values in A & B columns...?

For example, Row 1 and Row 4 are actually same; Row 2 & 5 are same too. How can I set to ask the worksheets to automatically find those identical rows and let it highlight the duplicated rows (like row #4 & #5 here), so that I can check and decide whether to delete the duplicated rows manually?

I don't really know much about Numbers...

Hope some of you can help me, thanks in advance.

MacBook Air (M1, 2020)

Posted on Oct 25, 2024 3:55 AM

Reply

Similar questions

Highlight duplicate rows by grouping? In Numbers is there any way to highlight duplicate rows that occur in a grouping. By grouping, I don’t mean any of the built in tools for creating categories. Instead, I am referring to a column I am using for grouping data. Example: In the example, column B "Type" is used to group the data. The Fruit data has the duplicate entry "Apple". However, the "Apple" entry under "tech" wouldn't count as a duplicate, because it's part of a different group. Is there anyway I can highlight the duplicates (in this case rows 2 & 5, and 9 & 11). Also, can I filter it so, I only see each duplicate per a category to make them easier to delete? Thanks!
159 2

2 replies

Level 8

36,134 points

Oct 25, 2024 9:26 AM in response to Shek8964

There are various ways with formulas but I find the quickest way is to use the categories feature in Numbers.

Start with a table like this (note that in Numbers you will generally want the first row to be a Header Row).

Choose 'Add Category for A' from the dropdown by the column letter.

Choose 'Add Category for b' from the dropdown by the second column letter:

Now you will see the pairs of duplicates:

You can select rows in that view and delete as needed. When done go in the menu to Organize > Turn Categories Off.

To familiarize yourself with Numbers be sure to visit Help > Numbers Help in the menu if you haven't done so already.

SG

Reply

Shek8964 Author

Level 1

4 points

Oct 30, 2024 8:51 AM in response to SGIII

Dear SG, Thank you so much for your help. I think I understand how it works.

Reply

How to automatically find identicals in worksheet?

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up