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

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