The condition here is that A1 in your first sheet is not equal to A1 in your second sheet. =IF(Groups!A1 Updates!A1, "Groups:"&Groups!A1&" and Updates:"&Updates!A1, "") It's an IF function with a reference to your tables: Enter the formula into A1, it may be easier to copy it from our blog post. You will need a new sheet for the report. If you want to see which values differ in your sheets, there is a formula that will compare each cell. Compare Excel spreadsheets and merge changesįind every difference in Excel sheets with a formula.Compare data in Excel using Conditional Formatting.Find every difference in Excel sheets with a formula.You can click the same button to return to your spreadsheet. Use this New Window button in the same group and then enable the option to view them side by side. If you have your tables in the same file, you need to open one of the sheets in a new window first. You can switch it off using the Synchronous Scrolling icon. As you scroll, you will see the same rows.You can switch them to vertical view with the help of Arrange All, Vertical, and click Ok. Now you can see them one after the other.Go to View tab, find the Window group and click View Side by Side.There is a button in Excel that lets you do just that: If you compare small tables for just a few possible changes, you can view the files side by side. How two compare two Excel files: video transcript