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.
