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

Most frequent string in a column matched against a value in its ro 1
Any formula to return the most frequent bin range? 15
Determine Most/Least Frequent Date from List 2
Formula to Count and Return Most common Value in a Dynamic Named Range 1
How to determine the value from a list? 6
How to determine the values from a list? 8
How to determine the value from a list? 3
Formula to Count and Return Most common Value in a Dynamic Named Range 1

Top