Sorted Data
 

I have columns that have quite a bit a bit of data in them and some of the
numbers are the same.. I would like to be able to find the number that
appears most often, then the second most appearing number and third, all the
way to the fifth most appearing number. I have been able to use "MODE" to
find the most often used number but have not be able to find out how to do
the rest. Any help would be appreciated.

Sorted Data
 

hi
i just did a test with the countif function. small test but it worked.
=COUNTIF(A$1:A$33,A1)
assuming your numbers are in column A, use a helper column with the countif
functions keying on Column A. sort by helper column then number column(A?)
use absolute references on the range so that the range will remain constant
when you copy the countif function down the helper column.

regards
FSt1



"Norm" wrote:

I have columns that have quite a bit a bit of data in them and some of the
numbers are the same.. I would like to be able to find the number that
appears most often, then the second most appearing number and third, all the
way to the fifth most appearing number. I have been able to use "MODE" to
find the most often used number but have not be able to find out how to do
the rest. Any help would be appreciated.