View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
broer konijn
 
Posts: n/a
Default 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