### Excel Magic Trick 1326

October 2, 2017

DESCRIPTION See how to Conditionally Format Text Modes with: PivotTable, Array Formula or Power Query: (00:17) Introduction (01:52) PivotTable & MATCH formula. (08:23) Array Formula with the functions: MATCH, IF, ISTEXT, MODE.MULT, N, N(IF,1 formula […]

### Excel Magic Trick 1314

August 17, 2017

DESCRIPTION See Excel Formula To Create Sorted Unique List On Mixed Data: (00:08) Problem set up (01:26) Essential logical behind Sorting Formula (04:38) Unique Count Formula For Mixed Data (08:27) Formula to Extract a Sorted […]

### Excel Magic Trick 1302

June 29, 2017

DESCRIPTION Learn how to create an Array Formula to list multiple text modes in a single cell using the functions, MATCH, MODE.MULT, HLOOKUP and the wildcard for “any text” asterisk, “*”, and the new Excel […]

### Excel Magic Trick 1301

June 26, 2017

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 […]

### Excel Magic Trick 1300

May 29, 2017

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 Magic Trick 1179

November 23, 2015

Calculate Mean, Median and Mode From Data Set DESCRIPTION See how to: (00:30) Mean using AVERAGE function (02:15) Median using MEDIAN function (03:17) Mode using MODE.MULT, SMALL and IFERROR functions

### Excel Magic Trick 1118

April 18, 2015

DESCRIPTION See how to Extract Word That Occurs Most Frequently: (00:07) MODE calculation for text. (00:57) COUNTIFS function for basic mode calculation (01:38) INDEX, MODE and MATCH function (with function argument array operation) to extract […]