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