Read my answer again. In your case, both 1 and 2 are the most repeating
values. In your first example, MODE returns 1, which occurs as often as 2
and 1 appears first, so it is returned. In your second example 2, occurs as
often as 1 and 2 occurs first, so it is returned.

Tyro

"Guy Lydig" wrote in message
...
I'm sorry--it does not return the largest value, it returns the uppermost
value. Why?

Example
1
1
2
2
4
Mode = 1

2
2
1
1
4
Mode = 2

Really the Modes are 1 and 2.

"Guy Lydig" wrote:

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