Excel Magic Trick 761: Formula Displaying Multiple Modes & Counting Modes Excel 2010 MODE.MULT

Download Excel Start File people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT7… Download file: people.highline.edu/mgirvin/ExcelIsFun.htm See how to use the Array Function MODE.MULT. See how to display the multiple modes without NAs using MODE.MULT, learn about a formula that will count all the Modes and see a formula with the functions MODE.MULT, ROWS, COUNT, INDEX and IF. Response to: Excel Magic Trick 536: List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Function

• #science_technology
• #excel
• #2007
• #2010
• #excelisfun
• #mike
• #gel
• #girvin
• #highline
• #community
• #college
• #slaying
• #dragons
• #array
• #formula
• #with
• #the
• #functions
• #modemult
• #rows
• #count
• #index
• #if
• #function
• #displaying
• #multiple
• #modes
• #basic
• #statistics