Excel Is Fun

Excel Magic Trick 1254

December 8, 2016 0

DESCRIPTION Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula? Learn how to create solution to lookup an item where two values are closets in value: (00:10) Problem Introduction (00:36) Helper Column […]

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

Dueling Excel

Dueling Excel 110

October 5, 2016 0

3 VLOOKUPS Calculate Cost Based on Product, Packaging, Discount DESCRIPTION See Mr Excel and excelisfun use two methods to calculate the total costs when there are three factors that go into calculating costs: Product Name, […]

Excel Is Fun

Excel Magic Trick 1235

October 3, 2016 0

DESCRIPTION 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP Learn how to do a two way lookup to retrieve the conversion rate for currencies: (00:11) Two-Way Lookup for Currency Conversion Problem […]

Dueling Excel

Dueling Excel 105

September 21, 2016 0

Count Between Words DESCRIPTION See Mr Excel and excelisfun use two methods to count between words using formulas and VBA. INDEX and MATCH and COUNTA functions to count between words WORKBOOKS

Dueling Excel

Dueling Excel 100

September 7, 2016 0

Two Way Lookup Formula and Conditional Formatting! DESCRIPTION See Mr Excel and excelisfun use two methods to: 1. Mr Excel creates formula to do Two Way Lookup using INDEX and 2 MATCH functions 2. Excelisfun […]

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

Dueling Excel

Dueling Excel 88

July 27, 2016 0

Highlight Cumulative Top 70% DESCRIPTION See Mr Excel and excelisfun use two methods to Highlight Cumulative Top 70%. Two long winded methods to highlight, not top 70% values, but the values that make up 70% […]

Dueling Excel

Dueling Excel 78

May 18, 2016 0

Extract Top Two Customers In Each Industry with Formula (2 Examples) DESCRIPTION See Mr Excel and excelisfun Extract Top Two Customers In Each Industry with 2 array Formulas that use the AGGREGATE, IF, COLUMNS, INDEX, […]

Dueling Excel

Dueling Excel 75

April 27, 2016 0

Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX? DESCRIPTION See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation using the OFFSET and INDEX functions. WORKBOOKS