Excel Magic Trick 1417

Excel Functions Ranking Unit & Total Profit for Products within Manufacturer

DESCRIPTION

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.
(00:11) Introduction
(01:23) SUMIFS function to add Profit
(02:52) RANK.EQ function to rank profits. Compare and Contrast the functions RANK, RANK.EQ and RANK.AVE
(05:36) COUNTIFS function to rank with criteria (multiple conditions), where we want to rank Product Profits within the Manufacturer Name.
(08:34) Two VLOOKUP Functions to calculate Profit per unit for each Product
(10:25) RANK.EQ function to rank profits per unit
(10:53) COUNTIFS function to rank with criteria (multiple conditions), where we want to rank Product Unit Profit within the Manufacturer Name.
(11:40) Summary

WORKBOOKS

Download “Excel Magic Trick 1416-1420” Excel-Magic-Trick-1416-1420.zip – Downloaded 25 times – 4 MB




Be the first to comment

Leave a Reply