Microsoft Office Tutorials and References
In Depth Information
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
To see whether there is a two-way tie, use
To see whether there is a three-way tie, use
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!
Search JabSto ::

Custom Search