I have 2 columns of numbers. I want to count number of cells in Column B that are different from Column A, i.e. =Countif(B1,"<>"&A1).
How can I do this without using adding 125 countif formulas (I have 125 rows)? I also have the B cells conditionally formatted if <> A1 but I cannot find how to use this condition in a formula. I hope someone can help me.