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.
--
Gary's Student


"SBCPA" wrote:

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.