Microsoft Office Tutorials and References

In Depth Information

**Syntax**

Figure 14.5.

Figure 14.5.
MODE.MULT

MODE.MULT is challenging to use.

is challenging to use.

In row 14 of
Figure 14.5
,
a nonarray formula counts how many results the

MODE.MULT function will return. Using =COUNT(MODE.MULT(B3:B12)) is

probably the best way to go.

To return the first mode, you can use

=MODE.SNGL(range)

To see whether there is a two-way tie, use

=IF(COUNT(MODE.MULT(range))>1,INDEX(MODE.MULT(range),2),"")

To see whether there is a three-way tie, use

=IF(COUNT(MODE.MULT(range))>2,INDEX(MODE.MULT(range),3),"")

You can continue this pattern for as many possible modes as you might ex-

pect. In an N-row data set, there might be as many as N/2 possible modes!