What formula do you use to look at a spread sheet and find the most
frequently used number besides a MODE function. The problem I am
haveing is I have used a MODE function to find the most frequent
number, but now I need to find the second most used number and also the
thrid and fourth most used numbers. But if I try and use a MODE function
I do not know how to write it to not keep returning the most frequent
number over and over???? Can ANYONE show me how to write a formula to
not look for a value that has all ready been found in an array as the
most frequent, I need to find the 5 most common numbers in an
spreadsheet, bottom line...

Thanks


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