Excel Is Fun

Excel Magic Trick 1169

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

Dueling Excel

Dueling Excel 041

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

Excel Is Fun

Excel Magic Trick 1153

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

Dueling Excel

Dueling Excel 036

VLOOKUP w Approximate Match & Unsorted Table DESCRIPTION See Mr Excel and excelisfun do a VLOOKUP for an approximate match when the table is not sorted. See Mr Excel create the exact match for his [Read More >>>]

Dueling Excel

Dueling Excel 035

3 Way Lookup INDEX or OFFSET function? DESCRIPTION See Mr Excel and excelisfun do a three way lookup. Compare a method that uses INDEX, MATCH and OFFSET function to a second method that uses INDEX [Read More >>>]

Dueling Excel

Dueling Excel 034

Dynamic Range for Adding Three Methods DESCRIPTION See Mr Excel and excelisfun add a range of values that is dynamic in two directions. The range of values to add changes depending on what you select [Read More >>>]

Dueling Excel

Dueling Excel 032

Three Methods for 2-Way Look DESCRIPTION See Mr Excel and excelisfun do two-way lookup three different ways: 1.INDEX and MATCH functions 2.VLOOKUP and MATCH functions 3.INDIRECT function and the Intersection Operator WORKBOOKS

Dueling Excel

Dueling Excel 029

Existing Customers In Prospect List? DESCRIPTION See Mr Excel and excelisfun compare a customer list and prospects list to see if customers are in the prospects list. Then remove the duplicates. See the MATCH, VLOOKUP [Read More >>>]