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

Download Excel Start File people.highlin...
Download file: people.highlin...
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