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.

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

Top