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

Excel Magic Trick 1299

May 25, 2017 0

DESCRIPTION Learn how to: create Automatic Calendar Table in Data Model, New in Excel 2016. This ability was not in earlier versions of Excel. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1298

May 22, 2017 0

DESCRIPTION Learn how to Group By Date in Power Pivot Data Model, New in Excel 2016. This ability was not in earlier versions of Excel. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1297

May 18, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Test from a Rectangular (Improper Lookup Table) with COUNTIFS Function with a Join Array Operation to create the OR Criteria Array that goes into the criteria argument& then the […]

Excel Is Fun

Excel Magic Trick 1296

May 15, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Test from a Rectangular (Improper Lookup Table) with COUNTIFS Function with OR Criteria & SUMPRODUCT function. WORKBOOKS

Excel Is Fun

Excel Magic Trick 1295

May 11, 2017 0

DESCRIPTION Learn how to create random transaction description codes for products by randomly looking up a row from a product lookup table with the INDEX and RANDBETWEEN functions and then join them with a dash […]

Excel Is Fun

Excel Magic Trick 1294

May 8, 2017 0

DESCRIPTION If you do not have a Proper Data Set Lookup Table, but rather a Rectangular Improper Lookup Table, learn how to create a single cell formula to Score Myers-Briggs Assessment (Test). This amazing formula […]

Excel Is Fun

Excel Magic Trick 1293

May 4, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) with a single cell lookup array formula that uses the LOOKUP and SUMPRODUCT functions and points to a proper data set. WORKBOOKS