Excel Magic Trick 1301

Sorted List of Modes in Single Cell with TEXTJOIN Array Formula

DESCRIPTION

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.

WORKBOOKS

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




Be the first to comment

Leave a Reply