Dueling Excel

Dueling Excel 127

February 1, 2017 0

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 […]

Excel Is Fun

Excel Magic Trick 1248

November 17, 2016 0

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 […]

Excel Is Fun

Excel Magic Trick 1247

November 14, 2016 0

DESCRIPTION Adding with Case Sensitive Criteria: EXACT & SUMPRODUCT Learn how to Add with Case Sensitive Criteria: EXACT & SUMPRODUCT. This video builds on the last video, Trick 1246: Counting with Case Sensitive Criteria: EXACT […]

Excel Is Fun

Excel Magic Trick 1246

November 10, 2016 0

DESCRIPTION Counting with Case Sensitive Criteria: EXACT & SUMPRODUCT Learn how to create EXACT & SUMPRODUCT functions array formula to count with Case Sensitive Criteria in Excel: (00:09) Intro to topic and look back to […]

Dueling Excel

Dueling Excel 116

October 26, 2016 0

Extract Individual Letters From Cell and do Lookup Adding, then… DESCRIPTION See Mr Excel and excelisfun use two methods to do lookup adding from a cell and then show one of three categories: ‘Under Zero”, […]

Dueling Excel

Dueling Excel 112

October 12, 2016 0

Two Way Lookup Cell Address to Create Dynamic Range: Formula or VBA DESCRIPTION See Mr Excel and excelisfun use two methods to lookup a cell reference in a two way table and create a dynamic […]

Excel Is Fun

Excel Magic Trick 1236

October 6, 2016 0

DESCRIPTION Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT? Learn how to count numbers that contain the whole number 4: (00:11) Problem Introduction (01:05) COUNTIFS formula that uses Cell References, Comparative Operators and […]

Excel Is Fun

Excel Magic Trick 1226

September 1, 2016 0

DESCRIPTION Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples) Learn how to Compare 2 Lists, Extract Items In List 2 That are NOT in List 1: (00:12) […]

Excel Is Fun

Excel Magic Trick 1224

August 25, 2016 0

Which Similar Array Formula? Compare Number of Array Operations DESCRIPTION Learn how to build similar formulas and compare the number of array operations in order to decide which formula might be most efficient: (00:08) Problem […]