I need a formula to count when numbers are not equal.
I have 2 columns of cells, 20 rows high, I need to count how ,many times the rows don't match.
Ex. row 1 If c4<>b4, count 1, if c5<>b5, count 1, if c6<>b6, count 1......So if in the 20 rows I have 5 rows that don't match, count 5.
Solved by G. E. in 23 mins