| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formular for the SECOND highest frequency
Actually your first formular also can be worked, but one key point, I didn't
realised that the highest frequency value should be shown in the cell of H1 first. As a result, your formular show "2", which is the highest frequency value. Many thanks for your time! Wilchong T. Valko wrote: Ok, good deal. Thanks for the feedback! Dear Mr. Valko I placed your suggested Excel formula in the cell of H20. The result [quoted text clipped - 16 lines] I hope you can advice me on this. Many thanks, Wilchong -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200903/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Second highest frequency | New Users to Excel | |||
| 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 | |||
| Need To Complete Formular To Sort And Show Frequency | Excel Discussion (Misc queries) | |||
| Need A Formular To Sort And Show Frequency | Excel Discussion (Misc queries) | |||
Hybrid Mode
