Excel Is Fun

Excel Magic Trick 1340

October 20, 2017 0

DESCRIPTION See how to create expandable range in an Excel Table as part of a COUNTIFS formula that calculates a running count of names as there are entered into the table: (00:12) Introduction (00:35) Example […]

Excel Is Fun

Excel Magic Trick 1327

October 3, 2017 0

DESCRIPTION See how to create a Formula to Count Words in a Column with Mixed Data: Not COUNTA, but with COUNTIFS with the criteria “*?” (Count Text with One or More Characters) and NOT a […]

Excel Is Fun

Excel Magic Trick 1324

September 28, 2017 0

DESCRIPTION See how to extract records with a formula: (00:17) Problem Introduction (01:23) Use ROWS as the Number Incrementor in a Data Extraction Formula when the criteria does not change as the formula is copied. […]

Excel Is Fun

Excel Magic Trick 1322

September 26, 2017 0

DESCRIPTION See how to use Excel, DAX, Power Query or SQL to Calculate Average GPA with one condition when the formulas need to ework backwards across a One To Many Relationship between Two Tables: (00:16) […]

Excel Is Fun

Excel Magic Trick 1311

August 7, 2017 0

DESCRIPTION See an Array Formula that can extract (from a proper data set) multiple invoice items for one lookup value & show total. See the functions: COUNTIFS, ROW, AGGREGATE, ROWS, INDEX, IF and SUMIFS. See […]

Excel Is Fun

Excel Magic Trick 1310

August 3, 2017 0

DESCRIPTION Calculate Minimum Value Greater Than Zero. See the functions: SMALL, COUNTIFS and AGGREGATE (LARGE). WORKBOOKS

Excel Is Fun

Highline Excel 2013 Class Video 46

July 28, 2017 0

DESCRIPTION Topics in this video: 1. Formulas for Min and Max values 2. Formulas for Chart Labels 3. COUNTIFS formula to count between upper and lower numbers. BETWEEN Criteria. AND Criteria. 4. Histogram Chart with […]

Dueling Excel

Dueling Excel 149

July 5, 2017 0

DESCRIPTION See Mr Excel and excelisfun have an epic back and forth duel that shows many ways to add or count with OR Criteria: (00:15) PivotTable (01:12) Excel Table feature with a Total Row with […]

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