ExcelBanter - COMPARE DATA FOR CHANGES

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COMPARE DATA FOR CHANGES (https://www.excelbanter.com/excel-worksheet-functions/42022-compare-data-changes.html)

SBCPA

COMPARE DATA FOR CHANGES

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.

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.
--
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.

All times are GMT +1. The time now is 07:14 PM.