Excel Is Fun

Excel Magic Trick 1190

February 1, 2016 0

Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for […]

Excel Is Fun

Excel Magic Trick 1187

January 11, 2016 0

Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions DESCRIPTION See how to create a formula to Lookup Every 5th Item In a Column using INDEX and ROWS functions.

Dueling Excel

Dueling Excel 58

January 6, 2016 0

Sorting Formula For Biggest Sales and Sales Rep Names with Ties DESCRIPTION See Mr Excel and excelisfun create formulas for sorting biggest to smallest (descending) numbers that can deal with ties, then sort the sales […]

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

Excel Is Fun

Excel Magic Trick 1172

October 26, 2015 0

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

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