| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to look for the minimum value for MODE?
There is a list of numbers
210,210,209,209,209,208,,207,207,207 I would like to look for the minimum value for the high frequency of occurrence. In this case, 209 has 3 occurrences and 207 has 3 occurrences., if I use MODE function, then it will return the maximum as default [209], but I would like to return the minimum [207]. Does anyone have any suggestions? Thank for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
| Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
| How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
| Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
| coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Threaded Mode
