Apple Intelligence is now available on iPhone, iPad, and Mac!

⏺ Join the discussion

⏺ Press release

⏺ Watch the video

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!
151 2

2 replies

Level 8

36,026 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