Dueling Excel

Dueling Excel 148

June 28, 2017 0

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

Dueling Excel

Dueling Excel 147

June 21, 2017 0

DESCRIPTION See Mr Excel and excelisfun Avoid Sheet References From Current Sheet in a formula: 1. View, Arrange Vertically 2. Use Function Argument Dialog Box (Zack Barresse trick) WORKBOOKS

Dueling Excel

Dueling Excel 146

June 14, 2017 0

DESCRIPTION Excel Truel: This is a simple Excel task: multiplying, but for a kid, its seems amazing! See Isaac Excelisfunner Girvin, Bill Mr Excel Jelen and Mike excelisfun Girvin try to multiply in Excel. WORKBOOKS

Dueling Excel

Dueling Excel 145

June 7, 2017 0

DESCRIPTION See Mr Excel and excelisfun convert YYYYMMDD Numbers To Dates: 1. Text To Columns 2. Formula with DATE, LEFT, RIGHT, MID functions 3. Flash Fill 4. Text Function with custom Number Format 0000\/00\/00 WORKBOOKS

Dueling Excel

Dueling Excel 144

May 31, 2017 0

DESCRIPTION See Isaac Excelisfunner Girvin, Bill Mr Excel Jelen and Mike excelisfun Girvin have mirror fun in Excel. Copy stuff like it was a mirror with: Relative Cell Reference Paste Special Picture Link View New […]

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