Download Excel File: https://excelisfun.net/files/EMT1674.xlsx
Learn how to create a dynamic list of multiple text value modes. See how to do it in Microsoft 365 Excel and older versions of Excel.
Topics:
1. (00:00) Introduction.
2. (00:55) List Number Modes in Microsoft 365 Excel. MODE.MULT Function for getting multiple number value modes.
3. (01:50) List Number Modes in Older Versions of Excel. MODE.MULT, COUNT, ROWS, INDEX and IF functions for getting multiple number value modes.
4. (02:58) List Text Modes in Microsoft 365 Excel. Use INDEX, MODE.MULT and XMATCH functions for listing multiple text value modes.
5. (04:48) List Text Modes in Older Versions of Excel. Use IF, COUNT, ROWS, AGGREGATE, INDEX, MODE.MULT and MATCH functions for listing multiple text value modes.
6. (05:32) Summary and End Video Links