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

Excel Is Fun

Excel Magic Trick 1292

May 1, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) in Excel with Two Formulas based on a proper lookup table created with Power Query (Excel 2016 Get and Transform): (00:12) Problem Introduction (00:50) Use Power Query […]

Excel Is Fun

Excel Magic Trick 1291

April 27, 2017 0

DESCRIPTION Learn how to Score Myers-Briggs Assessment (Test) in Excel with Two Formulas: (00:13) Problem Introduction (01:50) Formula 1: Lookup correct letter for each answer. An array Operation, COLUMN function, SUMPRODUCT function and INDEX Function. […]

Excel Is Fun

Excel Magic Trick 1290

April 24, 2017 0

DESCRIPTION Learn how to create dynamic ranges using OFFSET or INDEX functions for an unusual multiple lookup table situation where the multiple tables are in a single table and the source data from a database […]

Excel Is Fun

Excel Magic Trick 1285

April 6, 2017 0

OR Criteria & AND Criteria for Max & Min Calculations (5 Examples) DESCRIPTION Learn how to calculate the MIN and MAX values when there is complex criteria that mixes OR Logical Tests and AND Logical […]