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% […]
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, […]
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
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 […]
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 […]
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 […]
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.
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 […]