count changes between 2 columns

S

SLB

I have 2 columns; one that has the original data in it and one that tracks
any changes that have been made to the original data. if there were no
changes then the number stays the same in both columns. I need to count how
many changes were made; in other words, how many differences exist between
the columns.

COLUMN A COLUMN B
82 82
1 5
4 4
62 62
20 79

So the answer I need to get in the above example is 2 since there were 2
changes (or 2 differences between the columns).

Any thoughts?????
-sophia
 
S

SLB

Thank you!! That worked great! But I forgot that I also have blanks in the
second column that can't be counted as part of the change. Is there a way to
add to that formula to make it ignore blanks?
 
Top