Hi,

Returning the highest value isn't the default for mode, in the event of a
tie it returns the first value for mode. So to get the lowest sort your list
in ascending order.

Mike

"Eric" wrote:

There is a list of numbers
210,210,209,209,209,208,,207,207,207
I would like to look for the minimum value for the high frequency of
occurrence.
In this case, 209 has 3 occurrences and 207 has 3 occurrences., if I use
MODE function, then it will return the maximum as default [209], but I would
like to return the minimum [207].
Does anyone have any suggestions?
Thank for any suggestions
Eric