Excel Forum
Similar Content
3 Methods to Remove Spaces Between Text in Excel
Tutorial: How to remove spaces from the middle of text in Excel.  This includes removing all space...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Increment a Value Every X Number of Rows in Excel
Tutorial: (New Easier Version for Excel 2010 and Later) How to increment a value, number, percent, e...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.