Excel Forum

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

Download file: https://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

Got a Question? Ask it Here in the Forum.