best method to determine "most frequent value" from a dynamic list

B

broer konijn

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!:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any formula to return the most frequent bin range? 15
Most frequent string in a column matched against a value in its ro 1
How do I find the highest of the most repeating values in a list ofnumbers ie. the max of the modes 2
Determine Most/Least Frequent Date from List 2
Finding the least frequent value in an array 3
Changing a cell value from another cell. 5
MODE - Second most frequent value 2
How to determine the value from a list? 6

Top