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