Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Formula to Get Value of Last Non-Empty Cell in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel....
Print Only Specific Parts of a Worksheet in Excel
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...



Excel Magic Trick 536: List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Function


See how to use calculate MODE (statistics) when there is more than one Mode:
1.List all modes with MODE.MULT function (New in Excel 2010) Entered as an array
2.MODE.SNGL function (New in Excel 2010)
3.MODE.MULT and ISERROR functions together to list all modes
4.COUNT the number of modes with COUNT and MODE.MULT (Richard Schollar Mr Excel Message Board)
5.SUM FREQUENCY MAX and IF array formula to count MODEs (Excel 2007 or Excel 2003)
6.Frequency Distribution and COUNTIF and MAX functions (Excel 2007 or Excel 2003)
See Excel 2010 New Functions





Got a Question? Ask it Here in the Forum.