Dueling Excel

Dueling Excel 56

December 23, 2015 0

Copy Formula Down, Have Range Move Across DESCRIPTION See Mr Excel and excelisfun create formulas that can be copied down across the rows and have the range in the function move across the columns. See […]

Dueling Excel

Dueling Excel 53

December 2, 2015 0

Extract State When Text String Has Varying Number of Commas DESCRIPTION See Mr Excel and excelisfun show how to do a VBA and an array formula method to extract State data from a column of […]

Dueling Excel

Dueling Excel 52

November 25, 2015 0

Lookup Two Criteria: SUMIFS, DGET, or Array Formula? DESCRIPTION See Mr Excel and excelisfun lookup a value given two criteria. You will see three formulas: SUMIFS formula, DGET formula, and an array formula that uses […]

Excel Is Fun

Excel Magic Trick 1174

November 2, 2015 0

Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) DESCRIPTION See three methods for lookup situations where you have two lookup values: (00:10) What to do if you have two look values […]

Dueling Excel

Dueling Excel 046

October 21, 2015 0

Lookup a value and Retrieve the two items to the Right INDEX & MATCH DESCRIPTION See Mr Excel and excelisfun: lookup a value and the retrieve the values 1 and 2 to the right of […]

Excel Is Fun

Excel Magic Trick 1169

October 15, 2015 0

Are Items In Row In Master List? Filter & Conditionally Format To Highlight DESCRIPTION See how to Match Ingredients for a Drink with the data base for all drink ingregients: (00:13) Problem Setup (00:35) MATCH […]

Dueling Excel

Dueling Excel 041

September 16, 2015 0

VBA or Formula Extract Prefix for VLOOKUP DESCRIPTION See Mr Excel and excelisfun do VBA and an array formula to extract a varying length number prefix and then use that as the lookup_value for VLOOKUP. […]

Excel Is Fun

Excel Magic Trick 1153

August 20, 2015 0

Unique Count For Name & Date: Array Formula, 2013 PivotTable, More… DESCRIPTION See how to: (00:08) Problem Set Up (00:55) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula (02:38) Remove […]