try using pivot tables...it will show the count of all the numbers


"DArinello" wrote
in message ...

I need to figure something out on my sheet. The "mode" function tells
you witch value repeats the most. I want to see if there is another
value that repeats just as much. Also, I want to see what value
repeats the second most.

Ex:
4
6
4
7
5
6
4
5
5

If I use the function: =mode(list). It will return, "4". By using
=countif((list),mode(list)) I see that that repeated 3 times.

I want a way to see that "5" also repeated 3 times and then that 6 is
repeated 2 times.


--
DArinello
------------------------------------------------------------------------
DArinello's Profile:
http://www.excelforum.com/member.php...o&userid=25589
View this thread: http://www.excelforum.com/showthread...hreadid=390089