I'm having problems with the syntax of a function. I want to count the number of time a number comes up, my formula would be;
=COUNTIF(A1:A50,A1<>A2). It's the A1<>A2 that I can't get to plug in correctly.
What would the SUMPRODUCT function look like to do the same thing?