Download File: https://excelisfun.net/files/EMT1417.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net
See how to use Excel Spreadsheet Formulas to rank profits and profits per unit for both All The Products and Products Within Manufacturer. Also see throughout the video various ways to copy a formula without changing the formatting.
1. (00:11) Introduction
2. (01:23) SUMIFS function to add Profit
3. (02:52) RANK.EQ function to rank profits. Compare and Contrast the functions RANK, RANK.EQ and RANK.AVE
4. (05:36) COUNTIFS function to rank with criteria (multiple conditions), where we want to rank Product Profits within the Manufacturer Name.
5. (08:34) Two VLOOKUP Functions to calculate Profit per unit for each Product
6. (10:25) RANK.EQ function to rank profits per unit
7. (10:53) COUNTIFS function to rank with criteria (multiple conditions), where we want to rank Product Unit Profit within the Manufacturer Name.
8. (11:40) Summary
9.

Related Videos:
Excel Magic Trick 1417: Excel Functions Ranking For Unit & Total Profit for Products within Manufacturer
Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer
Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer
Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns