Excel Magic Trick 1301

Sorted List of Modes in Single Cell with TEXTJOIN Array Formula


Learn how to create an array formula to show a sorted list of modes in a single cell. See the Functions: TEXTJOIN, INDEX, SMALL, MODE.MULT, COUNT, ROW, INDIRECT. Learn about difference (and history) between the MODE, MODE.SNGL and MODE.MULT functions.


Download “Excel Magic Trick 1301-1320” Excel-Magic-Trick-1301-1320.zip – Downloaded 529 times – 285 KB

Be the first to comment

Leave a Reply