### Dueling Excel 134

March 22, 2017

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

### Excel Magic Trick 1271

February 16, 2017

DESCRIPTION Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? Learn how to extract Top 20 values and dates for those values using Formulas when there are no duplicates, Array Formula for […]

### Dueling Excel 129

February 15, 2017

DESCRIPTION Dynamic Range Last Ten Numbers Column: OFFSET or INDEX Formula? See Mr Excel and excelisfun use two methods to create Dynamic Range For Last Ten Numbers in Coulmn: 1. OFFSET function to create dynamic […]

### Dueling Excel 124

January 11, 2017

DESCRIPTION Dynamic Stacked Line Chart See Mr Excel and excelisfun use two methods to lookup a column based on a date and then add all the values for the North Region 1. NA error Trick […]

### Excel Magic Trick 1259

January 5, 2017

DESCRIPTION Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula? Learn how to use two lookup values to lookup an item in a table: (00:11) Problem Introduction and discussion of default behavior for VLOOKUP […]

### Dueling Excel 123

January 4, 2017

DESCRIPTION Lookup Column and then Add With Criteria See Mr Excel and excelisfun use two methods to lookup a column based on a date and then add all the values for the North Region 1. […]

### Excel Magic Trick 1254

December 8, 2016

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 112

October 12, 2016

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 110

October 5, 2016

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 Magic Trick 1235

October 3, 2016

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