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

Dueling Excel

Dueling Excel 133

March 15, 2017 0

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

Dueling Excel

Dueling Excel 132

March 8, 2017 0

DESCRIPTION See Mr Excel and excelisfun use two methods to convert from the numbers 10.1 and 10.2 to 10.333 and 10.667, and the reverse using two methods: 1. DOLLARDE and DOLLARFR functions 2. MOD and […]

Dueling Excel

Dueling Excel 131

March 1, 2017 0

DESCRIPTION See Mr Excel and excelisfun use two methods to Prevent VLOOKUP from Returning a Zero: 1. Alter the lookup table so there are not empty cells 2. Custom Number Formatting 3. IF and VLOOKUP […]

Dueling Excel

Dueling Excel 130

February 22, 2017 0

DESCRIPTION Text Formula To Show Calculation (Not Formula) From A Cell See Mr Excel and excelisfun use two methods to show formula calculation in a cell: 1. Use Ampersand (Join Symbol), Text in Double Quotes, […]