| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Second highest frequency
Dear sir,
I have a series of number from A1:H1 (7,3,7,1,6,8,3,7). I need an Excel formular to describe the phenomenon of this particular series number: the frequency. If I want to to know the highest frequency number, the formula of MODE can give me the answer which is 7. However, I also need an formular which can give me answer: 3, because 3 appears two times in the series. The formular MODE only will give me the highest frequent number, that is 7. So, I don't know is there any formular can detect the second highest frequent number. Please advice. Wilchong -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200903/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highest, Second Highest , Third Highest and so on | Excel Discussion (Misc queries) | |||
| Display the Highest, Second Highest, Third Highest and so on... | Excel Discussion (Misc queries) | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| second highest value | Excel Discussion (Misc queries) | |||
| histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
Threaded Mode
