Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
Thread | Forum | |||
having a problem with IF and SEARCH | Excel Discussion (Misc queries) | |||
Xl search problem | Excel Discussion (Misc queries) | |||
Problem with search and replace data,thanks for you help in advance. | Excel Discussion (Misc queries) | |||
Problem with search | Excel Worksheet Functions | |||
Problem with search | Excel Worksheet Functions |