| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bin Array--Frequency | Excel Worksheet Functions | |||
| speedy way to do array-frequency? | Excel Discussion (Misc queries) | |||
| Using Solver with the 'Frequency Array' Function | Excel Worksheet Functions | |||
| frequency of occurance of all words in 2-D array | Excel Discussion (Misc queries) | |||
| Frequency Array and Bin Array | Excel Worksheet Functions | |||
Threaded Mode
