I am trying to compare Column A and Column B and put the number of differences in C1.
Example is attached
Thank you so much in advance... I know its simple to you braniacs!
I am trying to compare Column A and Column B and put the number of differences in C1.
Example is attached
Thank you so much in advance... I know its simple to you braniacs!
Try:
=SUMPRODUCT(--(A2:A11<>B2:B11))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
what if some of the cells contain text?
Should still compare and give the same count...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks