Excel Is Fun

Excel Magic Trick 1326

October 2, 2017 0

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 Is Fun

Excel Magic Trick 1314

August 17, 2017 0

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 Is Fun

Excel Magic Trick 1302

June 29, 2017 0

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 Is Fun

Excel Magic Trick 1301

June 26, 2017 0

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 Is Fun

Excel Magic Trick 1300

May 29, 2017 0

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

April 21, 2017 0

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

Formulas & Functions

AVERAGE, MODE, MEAN, And MEDIAN

June 20, 2015 0

Average Description Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers. Syntax AVERAGE(number1, [number2], …) The AVERAGE function syntax […]

Excel Is Fun

Excel Magic Trick 1118

April 18, 2015 0

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