Confirm That Numbers Match


Q. I need to be sure that a number at one end of a large spreadsheet matches another number at the other end. Since it’s tedious going back and forth to check, I wonder if you have a shortcut for making sure they match.

A. Excel has a simple solution. Say one number is in cell A1 and the other is in A2. In the cell where you want the numbers compared, enter this formula:

=exact(A1,A2)

If A1 and A2 match, the cell with the formula will read TRUE; if they don’t, it will display FALSE, as the screenshot at right illustrates.

SPONSORED VIDEO

How KPMG is innovating the audit

KPMG's global audit team is using cognitive technology and alliances with tech and university partners to drive audit innovation. See how.

SPONSORED REPORT

States look to unclaimed property for revenue

This free report outlines the escheat process, common types of AUP, how different states are handling it and how companies can plan for potential audits and liabilities.