Dueling Excel

Dueling Excel 143

May 24, 2017 0

DESCRIPTION See Mr Excel and excelisfun create two solutions for looking up and calculating a percentage commission that does not exceed the max amount for some of the products. See the functions: VLOOKUP, MIN, and […]

Dueling Excel

Dueling Excel 142

May 17, 2017 0

DESCRIPTION See Mr Excel and excelisfun do an average calculation with one condition: 1. PivotTable 2. Array Formula that uses AVERAGE and IF functions 3. SUMIF and COUNTIF together WORKBOOKS

Dueling Excel

Dueling Excel 141

May 10, 2017 0

DESCRIPTION See Mr Excel and excelisfun in an epic back and forth duel (7 back and forths) try to figure out how to lookup three different items in three different tables and then multiply the […]

Dueling Excel

Dueling Excel 140

May 3, 2017 0

DESCRIPTION One cell has a security name, ticker symbol, then price. The complicated part is that the security name might have 3, 4, or 5 words. How can you extract the last 2 words into […]

Dueling Excel

Dueling Excel 139

April 26, 2017 0

DESCRIPTION Tom would like to do a VLOOKUP to pull all employees for a given department. While VLOOKUP can not return multiple results, Bill and Mike come up with formulas to simulate the request. WORKBOOKS

Dueling Excel

Dueling Excel 138

April 19, 2017 0

DESCRIPTION NETWORKDAYS.INTL Amazing New “Any Weekend” Argument Learn about amazing new feature in the NETWORKDAYS.INTL function for counting workdays that will accommodate any weekend scenario. See counting workdays and Conditional Formatting for weekdays or weekend. […]

Dueling Excel

Dueling Excel 137

April 12, 2017 0

DESCRIPTION Start and End Date, What is Total Pay Over Period Given Month Salary? See Mr Excel and excelisfun use two methods to calculate Start and End Date, What is Total Pay Over Period Given […]

Dueling Excel

Dueling Excel 136

April 5, 2017 0

DESCRIPTION Variable Rent Calculation Based On Days: VBA, IF or VLOOKUP? See Mr Excel and excelisfun use two methods to calculate the total rent for a container based on a sliding scale: 1. VBA with […]

Dueling Excel

Dueling Excel 135

March 29, 2017 0

DESCRIPTION From Text to Math: VBA or Excel 4 Macro Function: EVALUATION See Mr Excel and excelisfun use two methods to convert a text string to a match expression that can calculate the correct answer: […]

Dueling Excel

Dueling Excel 134

March 22, 2017 0

DESCRIPTION Merge Product and Sub-Product Text; VBA or Wild INDEX Formula See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to […]