Dueling Excel

Dueling Excel 88

July 27, 2016 0

Highlight Cumulative Top 70% DESCRIPTION See Mr Excel and excelisfun use two methods to Highlight Cumulative Top 70%. Two long winded methods to highlight, not top 70% values, but the values that make up 70% […]

Dueling Excel

Dueling Excel 78

May 18, 2016 0

Extract Top Two Customers In Each Industry with Formula (2 Examples) DESCRIPTION See Mr Excel and excelisfun Extract Top Two Customers In Each Industry with 2 array Formulas that use the AGGREGATE, IF, COLUMNS, INDEX, […]

Dueling Excel

Dueling Excel 75

April 27, 2016 0

Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX? DESCRIPTION See Mr Excel and excelisfun create Dynamic Range For VLOOKUP and Data Validation using the OFFSET and INDEX functions. WORKBOOKS

Dueling Excel

Dueling Excel 70

March 23, 2016 0

Lookup & Return Last 5 Numbers in a List DESCRIPTION See Mr Excel and excelisfun create formulas that Lookup & Return Last 5 Items in a List using INDEX and COUNT functions. See a retractable […]

Excel Is Fun

Excel Magic Trick 1193

February 22, 2016 0

Count Distinct Words As They Are Entered In Column: Formula or Excel Table? DESCRIPTION See how calculate a running count for each unique (distinct) text items entered in column using two methods: (00:10) Problem setup […]

Dueling Excel

Dueling Excel 63

February 10, 2016 0

2 Criteria Lookup and Multiple Table Lookup From Different Sheets DESCRIPTION See Mr Excel and excelisfun do a 2 Criteria Lookup and Multiple Table Lookup From Different Sheets. Amazing Lookup Solution that: 1. Uses functions […]

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