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.

compare 2 tables.. table 2 is a week older with changes to some rows data finding what is different using numbers program

using numbers program..2 tables are the same except one is last weeks and the second is this weeks with changes in certain rows need to know what has changed in second table from the first table.

Mac mini, macOS 12.7

Posted on Nov 6, 2024 5:59 AM

Reply
3 replies

Nov 7, 2024 8:27 PM in response to paulfromindependence

You can also use Conditional Highlighting.





Select the body cells in the second table, got to the cell tab of the inspector pane at the right, click Conditional Highlighting and add a rule like the one shown in the screenshot.


To get the reference to the upper left body cell in the first table first click the little arrow and box icon and then click the cell in the first table. Make sure you have first selected all the body cells in the second table.


Use cell conditions in Numbers on Mac - Apple Support


SG


Nov 7, 2024 12:04 AM in response to paulfromindependence

I'm not quite sure about the layout of your two tables—whether they are on the same sheet, how much data they contain, or if the content is numeric or otherwise. More information might help.


First of all, regardless of whether the two tables are on the same sheet, it’s best to ensure the tables are aligned. Make sure that both tables have the same structure (e.g., the same number of columns and similar data types) for an accurate comparison.


If they’re not on the same sheet (for example, as shown below):


Create a new Sheet 3. Then in the corresponding cell, enter

"Sheet 1::Table 1::A2 - Sheet 2::Table 1::A2" or

"IF(Sheet 1::Table 1::A2 = Sheet 2::Table 1::A2, 0, 1)"

The first formula is used to compare numerical differences, while the second works for any content, including numbers.


If the result is not 0, it means that the content in the corresponding cells of the two sheets does not match.


Then, simply copy this formula across the cells where you need the comparisons.


If the two tables you need to compare are on the same sheet, the comparison method is quite similar to the one above. As long as both tables have a similar structure, you can subtract cell by cell or compare whether the contents match to find the difference.



compare 2 tables.. table 2 is a week older with changes to some rows data finding what is different using numbers program

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