MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Frequency?


Posted by Paul on February 06, 2002 3:05 PM

I need some formulas that will look at the range A9:E250, the numbers in the range will always be between 1 & 50, and give me the five numbers that appear the most times, in order of appearance, I have played around with =FREQUENCY but I cant get it to do what I need, without looking at each number in the range by it self. Thanks for your help.


Posted by Mark W. on February 06, 2002 3:10 PM

What's the "order of appearance" for 2-dimensional array? [NT]

Posted by Paul on February 06, 2002 3:16 PM

Re: What's the "order of appearance" for 2-dimensional array? [NT]

From the most to the least

Posted by Mark W. on February 06, 2002 4:15 PM

...And, what about ties? [NT]

Posted by Mark W. on February 06, 2002 4:28 PM

BTW, this array formula gives you a vertical array of 50 counts...

{=FREQUENCY(range,ROW(1:50))}

Posted by Paul on February 06, 2002 6:32 PM

Re: BTW, this array formula gives you a vertical array of 50 counts...

Maybe I am not expelling this right, I want to count the number of times the numbers are in the range how many ones, twosÂ…. And then for the formula to give me the top five numbers that are in the range the most times

Posted by Mark W. on February 07, 2002 6:44 AM

I understand...

...and the formula below does that count.