Rank based on category
I have a list of product categories and within each category is multiple
product models and their inventory value for the current month. I want to
rank each product model within it's category based on it's inventory value.
How do I create a formula that does this without having to sort the list each
time and determine the range to base the rank on. I just want one formula
that determines which category the product model is in and rank it based on
the inventory value
|