Whichever modal value is listed first is the value returned by MODE.

Biff

"Eric" wrote in message
...
There is a list of numbers
1,1,1,1,1,2,2,3,3,4,4,5,5,5,5,5 from cell A1 to A16
Mode(A1:A16) = 1
However, if I reverse the list of numbers
5,5,5,5,5,4,4,3,3,2,2,1,1,1,1,1
Mode(A1:A16) = 5
The frequency of occurrence between 1 and 5 is same, does anyone know what
the priority of Mode function is defined under this case?
Thank for any suggestions
Eric