Dueling Excel

Dueling Excel 116

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

Dueling Excel

Dueling Excel 112

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

Excel Is Fun

Excel Magic Trick 1236

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

Excel Is Fun

Excel Magic Trick 1226

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

Excel Is Fun

Excel Magic Trick 1224

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

Dueling Excel

Dueling Excel 96

LOOKUP Function Adding Bonus Amounts (Approximate Lookup Type) DESCRIPTION See Mr Excel and excelisfun use two methods to lookup a column of sales amounts in order to create a single cell formula that will add [Read More >>>]

Excel Is Fun

Excel Magic Trick 1222

Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format? DESCRIPTION Learn how to Create a Formula to Add Column Filled With Weights Like: 10kg, 33kg, 19kg: (00:10) Problem Setup (01:12) Customer Number [Read More >>>]

Dueling Excel

Dueling Excel 92

Round Invoice: ROUND or SUMPRODUCT – ROUND DESCRIPTION See Mr Excel and excelisfun use two methods to round the amounts on an Invoice so the SUM total is correct. WORKBOOKS

Dueling Excel

Dueling Excel 91

Rank Scores, But If Tie Award Highest Rank To The Largest Weight DESCRIPTION See Mr Excel and excelisfun use two methods to rank scores with the heights Weight: 1. See how to use RANK or [Read More >>>]

Dueling Excel

Dueling Excel 87

Positive Subtotals Only: PivotTable or SUMIFS DESCRIPTION See Mr Excel and excelisfun use two methods to add only the subtotals that are positive (ignore negative Subtotals using PivotTable Pivot Table or SUMIFS or SUMPRODUCT functions. [Read More >>>]