Dueling Excel

Dueling Excel 149

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

Dueling Excel

Dueling Excel 148

DESCRIPTION See Mr Excel and excelisfun create a Formula To Deliver TRUE When 3 Out 4 Tests Are Met 1. Boolean Formula with 4 Logical Tests (See Formula Evaluator) 2. SUM function with 4 Logical [Read More >>>]

Excel Is Fun

Excel Magic Trick 1297

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

Excel Is Fun

Excel Magic Trick 1296

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 1293

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

Excel Is Fun

Excel Magic Trick 1291

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

Excel Is Fun

Excel Magic Trick 1289

DESCRIPTION Why Doesn’t =ROW(1:LEN(A1)) Work? Learn 6 methods to remove “USD” from a column of values such as $ 1.23 USD, $ 56.34 USD, etc. that resulted from multiple downloaded CSV Files, including Replace feature, [Read More >>>]

Dueling Excel

Dueling Excel 133

DESCRIPTION See Mr Excel and excelisfun use two methods to sum the three biggest values that match three criteria (3 conditions) 1. Advanced Filter and LARGE and MAX value 2. SUM and LARGE functions with [Read More >>>]

Dueling Excel

Dueling Excel 127

DESCRIPTION Adding After & Before Dash: Array Formula or VBA? See Mr Excel and excelisfun use two methods to solve this very difficult adding problem: you must add numbers from a column of text strings [Read More >>>]

Excel Is Fun

Excel Magic Trick 1248

DESCRIPTION Add or Count Case Sensitive Contains Criteria: ISNUMBER, FIND, SUMPRODUCT Learn how to add with Case Sensitive Contains Criteria EXACT & SUMPRODUCT. This video builds on the last video, Trick 1246: Counting with Case [Read More >>>]