Sort your list in the reverse order, and then invoke the MODE function.
--
David Biddulph

"Eric" wrote in message
...
Do you have any suggestion on how to return the last value for mode?
Thank for any suggestions?
Eric

"Mike H" wrote:

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