Excel Is Fun

Excel Magic Trick 1301

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1300

DESCRIPTION Learn how to list all modes in single cell with TEXTJOIN & MODE.MULT. learn about the three different mode functions: MODE, MODE.SNGL and MODE.MULT. WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 32

DESCRIPTION Topics in this video: 1. Essential definition of array formula: operation on an array of items rather than single items. 2. Example of operation on single items: subtracting 2 cells. 3. Example of operation [Read More >>>]