SRT wrote:
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

--------------------

If you're trying to find more than just the #1 and #2 most frequent numbers,
there is a Histogram function provided with Excel. As I recall you have to
install the Analysis Tookpak add-in that came with Excel.

This can be set up to provide how many times each number in your data set occurs.

To invoke it click on ToolsDataAnalysis and pick Histogram from the list. The
Excel help system will describe the Histogram function and its options.

Good luck...

Bill