How to compare excel sheets for differences?

Asked By grace begum 0 points N/A Posted on - 07/26/2016

I want to know, how to compare excel sheets for differences? The excel sheets are in the same workbook, and I want to know which cells in the two spreadsheets contain different values?

• Status: Open
• Question Views: 3282
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Vogt Joan 0 points N/A #115068

How to compare excel sheets for differences?

You can compare two excel sheets by using a formula, and the desired result will be saved in a new sheet.

For this, all you have to do is:

Open a new sheet and type the following formula in the first cell A1:

=IF(Sheet1!A1<> Sheet2!A1, "Sheet1:"&Sheet1!A1&" vs Sheet2:"&Sheet2!A1, "")

Where Sheet1 and Sheet2 are the names of two sheets you want to compare.

The result will look somewhat like this:

If you want to highlight the difference in the cells values between two sheets, then in one of the worksheet, select all cells with values, then, click on conditional formatting, and create a new rule with the formula

=A1<>Sheet2!A1

Where Sheet2 is the other sheet, you are comparing.

About Vogt Joan

Questions
9

Answers
35

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 07/26/2016
• Question Category: MS Excel