=Countif(A:A,1) will count number of 1s in column A

HTH

"SouthCarolina" wrote:

I am trying to determine when I have repeats in a list of data. This is the
situation:

I have a list of data that contains numbers 1-99. I am trying to determine
when the numbers 1 and 2 appear in the same list and then count those
occurences. I have found a round about way of doing it, but do you know of a
faster way? Any help would be greatly appreciated. Thank you.