Count Function
 

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


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=546671

Count Function
 

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

Count Function
 

Thanks that works great

Can you tell how many are within a range of a number say 5 lower

ie
80 How many between 80 & 75
70 how many between 70 & 65


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=546671

Count Function
 

Try:

=COUNTIF(A:A, "<=" & A2)-COUNTIF(A:A, "<" & A2-5)

"Rikuk" wrote:


Thanks that works great

Can you tell how many are within a range of a number say 5 lower

ie
80 How many between 80 & 75
70 how many between 70 & 65


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=546671