Using the mode function
Try
=Mode(max(values))
let me know.
"Detra E." wrote in message
...
I have a group of numbers that I am trying to find the the mode of using
the
mode function. When I have multiple mode i.e 200 shows twice and 201 shows
twice the standard function returns the lower of the two modes and I want
it
to return the higher of the two modes. Is there anyone who can help me
figure
this out.
--
Detra (Thanks)
|