I am tring to do several MODE functions on a spreadsheet.
have done the first set of MODE functions for the sheet, what I am no
tring to do is run another MODE function that returns the next mos
frequent number to appear on the sheet. I can not figure out how t
write the MODE function to not look at the most frequent value bu
rather look at the second most frequent and the third, fourth and s
on... Can anyone PLEASE help with this??????

--
SR
-----------------------------------------------------------------------
SRT's Profile: http://www.excelforum.com/member.php...fo&userid=2553
View this thread: http://www.excelforum.com/showthread.php?threadid=38973

The MODE function returns the most common value in the data set. I don't
believe there is an option using MODE to get what you want.

"SRT" wrote in message
...

I am tring to do several MODE functions on a spreadsheet. I
have done the first set of MODE functions for the sheet, what I am now
tring to do is run another MODE function that returns the next most
frequent number to appear on the sheet. I can not figure out how to
write the MODE function to not look at the most frequent value but
rather look at the second most frequent and the third, fourth and so
on... Can anyone PLEASE help with this???????


--
SRT
------------------------------------------------------------------------
SRT's Profile:
http://www.excelforum.com/member.php...o&userid=25536
View this thread: http://www.excelforum.com/showthread...hreadid=389731