WORKBOOKS

WORKBOOKS

### 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 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 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 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 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 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 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 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 >>>]