ExcelBanter - array frequency data search

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - array frequency data search (https://www.excelbanter.com/excel-worksheet-functions/252934-array-frequency-data-search.html)

array frequency data search

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.

array frequency data search

On Sun, 10 Jan 2010 14:34:01 -0800, bishee
wrote:

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