The differences between these two tables

Question

Due to the need to frequently check two information tables in work, what method can be used to quickly verify the differences in information between the two tables? Thank you in advance.

Answer 1

Hi,

How do you want to verify the difference information?

You can try to use Conditional Formatting to highlight the different values in table.

I suggest you provide a sample about your tables, please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

What type of data do you want to compare? Kindly let me know in the comments.

Here are some ways by which you can compare data-

1. Conditional Formatting - You can create custom formatting rules to highlight differences between two tables like Duplicate Cells.
2. VLOOKUP- You can use this function to compare values in one table with values in another.
3. IF Statements- You can use IF statements to create custom logic for comparing data.
4. Pivot table "Difference" Feature- Create Pivot Tables for both tables and then you can use this feature to see the difference between both tables.
5. Cell Comments- You can add cell comments to individual cells to provide notes.

Best Regards.