Excel calculations

[Linzie]

What rule does Excel use to pick one mode from a multimodal data set?

 

[Jerry W. Lewis]

If there are multiple modes in the specified range, Excel's MODE()
function returns the first modal value encountered.

Jerry