MODE isn't working properly.
I am trying to find the mode of my array, but I want it to return nothing if
there is no number which occurs most often. Instead, they give me the first
number which appeared.
For example:
MODE(4, 3, 4, 3) will return 4, and
MODE(3, 4, 4, 3) will return 3.
Is there some way I can fix or bypass this?
|