One way:

B2: =COUNTIF(A:A, A2) - 1
C2: =COUNTIF(A:A, "" & A2)
D2: =COUNTIF(A:A, "<" & A2)

In article ,
Rikuk wrote:

I have a colum of numbers ranging for 0 to 100, for each row I need to
know

how many are the same value
how many are a higher value
how many are a lower value

Is there a easy way of doing this?

ie
rate same higher lower
80 1 1 2
50 0 4 0
55 0 3 1
80 1 1 2
90 0 0 4