Here are some methods on how to get it

http://tinyurl.com/pa35w


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)



"Mr Grim" <Mr wrote in message
...
I am trying to find the second most frequently occuring value in a given
data
set. I know MODE will give most frequent value but I need second, third,
fourth, and fifth most frequent values.