To compare two sheets for different data, we can make use of the excel formula and identify cells with different values.
To compare two Excel worksheets for differences, just open a new empty sheet, enter the following formula in cell A1, and then copy it down and to the right by dragging the fill handle.
=IF(Sheet1!A1<>Sheet2!A1,”false”,””)
This formula checks the A1 cell in sheet 1 with the A1 cell in sheet 2. If they are not equal then it will print “False” otherwise “Blank”
The formula will change based on the relative position of the column and row. As the result, the formula in A1 will compare cell A1 in Sheet1 and Sheet2, the formula in B1 will compare cell B1 in both sheets, and so on.
The result will look like this
The Blank cells indicate the cell values are matching and “False” indicates there is a difference in Values.