Dueling Excel

Dueling Excel 134

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1271

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 [Read More >>>]

Dueling Excel

Dueling Excel 129

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 [Read More >>>]

Dueling Excel

Dueling Excel 124

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1259

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 [Read More >>>]

Dueling Excel

Dueling Excel 123

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. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1254

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 [Read More >>>]

Dueling Excel

Dueling Excel 112

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 [Read More >>>]

Dueling Excel

Dueling Excel 110

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, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1235

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 [Read More >>>]