count changes between 2 columns

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

Guest

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

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

Count certain changes between columns 1
counting the number of times shown 3
Formula for counting cells with value 'x' provided Col U = 'y' 5
COUNT and SUM (please help!) 11
Rank and Sort 4
Count columns that meet criterias 3
Count based on 2 conditions 4
Count function 7

Back
Top