Excel Is Fun

Excel Magic Trick 1372

DESCRIPTION See how to Get the Total for each employee when the Employee Name column has many empty cells and the “TOTAL” is in a row without an employee name. See five methods: (00:13) Introduction [Read More >>>]

Excel Is Fun

Excel Magic Trick 1355

DESCRIPTION See how to extract records from a vertical column that contains Parent Names in Bold and Children Names in “Not Bold” and display parent and children records horizontally. Learn about the GET.CELL Excel 4 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1352

DESCRIPTION See how to create a formula that simultaneously looks up 3 item, joins then together in a single cell in order to produce a system code for CompanyName/PlantZipCode/. See 4 formula methods, including timing [Read More >>>]

Excel Is Fun

Excel Magic Trick 1334

DESCRIPTION See how to use Power Query (Get & Transform) and a set of Formulas to create a report that Adds Total Units for Each Product, Finds Max Units Sold for Each Product, and Lists [Read More >>>]

Excel Is Fun

Excel Magic Trick 1326

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

Excel Is Fun

Excel Magic Trick 1325

DESCRIPTION See how to create a report that require that we find the MIN and MAX Alphanumeric Academic Quarters for each Student ID. See eight different methods including: 1) VLOOKUP, 2) MIN & IF Array [Read More >>>]

Excel Is Fun

Excel Magic Trick 1321

DESCRIPTION See how to use (00:14) Intro (01:36) MIN & MAX & IF & SEARCH solution (Any Version of Excel) (07:49) INDEX & MATCH & LEFT solution (Any Version of Excel) (08:35) AGGREGATE & ISNUMBER [Read More >>>]

Excel Is Fun

Excel Magic Trick 1318

DESCRIPTION See how to use calculate Distinct Count with 1 Condition to create report and Chart for How Many Unique Visitors To Site Each Day with Two Methods: (00:13) Introduction (01:01) Excel 2016 Data Model [Read More >>>]

Excel Is Fun

Excel Magic Trick 1314

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

Excel Is Fun

Excel Magic Trick 1313

DESCRIPTION Learn how to create an Array Formula to Create Sorted Unique List in Cell. This is a huge complicated formula that requires the Excel 2016 function TEXTJOIN. There are many interesting formula elements in [Read More >>>]