array frequency data search

B

bishee

Hi.

I need to list, in order of frequency, the five most frequently occurring
numbers from a cell series (say A1:J10). I have been stumped for weeks on
this.

I need
Most frequently-occurring number
Next most-frequently number
etc (all the way to, say the fifth-most-frequently occurring number).

I can used =mode(a1:J10) to find the most frequently-occurring number - but
then I am lost.

Can someone help? It looks simple ... but it's beaten me.
 
L

Lars-Åke Aspelin

Hi.

I need to list, in order of frequency, the five most frequently occurring
numbers from a cell series (say A1:J10). I have been stumped for weeks on
this.

I need
Most frequently-occurring number
Next most-frequently number
etc (all the way to, say the fifth-most-frequently occurring number).

I can used =mode(a1:J10) to find the most frequently-occurring number - but
then I am lost.

Can someone help? It looks simple ... but it's beaten me.
Click to expand...

Hi bishee,

See answer to the same question posted by Bishee in another group.

Lars-Åke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data search problem 2
Detect String Frequency on dynamic entries 7
Top 10 Text Values 14
Help with a Worksheet Function please 2
Find the most frequent date 3
Mode Function or MODE Function -- Can't get it to work!! 4
How can I get the mode of a range? 1
Formular for the SECOND highest frequency 8

Top