MODE does not return the largest value. It returns the most frequently
occurring, or repetitive, value in an array or range of data. If more than
one value meets the criterion, MODE returns the first value that does.

Tyro



"Guy Lydig" wrote in message
...
Why does the MODE function return only the largest value if an array of
numbers has more than one mode? How can I get it to return all the modes?

TIA

Guy