Microsoft KB Archive/105431

= Microsoft Knowledge Base =

Excel: Unexpected Results Using the MODE Function
Last reviewed: September 12, 1996

Article ID: Q105431

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a, and 5.0
 * Microsoft Excel for the Macintosh, version 4.0

In Microsoft Excel, if you are using the MODE function and you are using a bimodal data set (the data set contains TWO values that occur most frequently), the function will return the bimodal value that occurs first in the data set.

Example
The formula MODE(4,4,4,5,5,5,1), returns the value 4. The formula MODE(4,5,4,5,4,5,1), returns the value 4. The formula MODE(5,4,4,5,4,5,1), returns the value 5. The formula MODE(1,5,4,5,4,5,4), returns the value 5.