COMPARE DATA FOR CHANGES

S

SBCPA

In a prior job we had a formula the check spreadsheets to see if information
had changes when two columns were compared. I cannot remember the formula.
 
G

Gary's Student

If the two columns with data are column A and column B, then in cell C1 enter:

=IF(A1=B1,"same","different")

and copy down.

This is suitable for locating changes to data. It is not suitable if cells
were inserted or deleted.
 
Top