Dueling Excel

Dueling Excel 56

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

Dueling Excel

Dueling Excel 53

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

Dueling Excel

Dueling Excel 52

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

Excel Is Fun

Excel Magic Trick 1174

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

Excel Is Fun

Excel Magic Trick 1172

Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT DESCRIPTION See how to: (00:38) INDEX and MATCH functions to lookup a column (00:50) Highlight non-contiguous ranges using Ctrl (03:13) Enter Formula into non-contiguous ranges using [Read More >>>]

Dueling Excel

Dueling Excel 046

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