COMPARE DATA FOR CHANGES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing info on 2 spreadsheets 1
Calculating Percent Change - Comparison Result is Negative 2
Comparison of columns using Conditional Formatting 3
Excel Help to copy information from one row at a time to another sheet 1
VLookup 15
changing cell background colors with formulas 5
Comparing two spreadsheets 2
Excel functions 0

Back
Top