|
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
|