| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
best method to determine "most frequent value" from a dynamic list
Currently I use the mode function for this, but is there another perhaps better way to determine the most frequent value from a list of values? I cannot use frequency, since my output should be one value, not an array. Any suggestions? Thanx!:) -- broer konijn ------------------------------------------------------------------------ broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402 View this thread: http://www.excelforum.com/showthread...hreadid=553718 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
best method to determine "most frequent value" from a dynamic list
http://www.cpearson.com/excel/lists.htm#MostCommon
-- Allllen "broer konijn" wrote: Currently I use the mode function for this, but is there another perhaps better way to determine the most frequent value from a list of values? I cannot use frequency, since my output should be one value, not an array. Any suggestions? Thanx!:) -- broer konijn ------------------------------------------------------------------------ broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402 View this thread: http://www.excelforum.com/showthread...hreadid=553718 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
| How to find the second most frequent number in a list? | Excel Worksheet Functions | |||
| Determine Frequency in Filtered List | Excel Worksheet Functions | |||
| List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
Hybrid Mode
