Rank based on category

V

vnvkatz

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
 
T

T. Valko

Try this:

A2:A20 = categories
C2:C20 = inventory value

Enter this formula in D2 and copy down as needed:

=SUMPRODUCT(--(A$2:A$20=A2),--(C2<C$2:C$20))+1
 
V

vnvkatz

Works perfect. Thanks

T. Valko said:
Try this:

A2:A20 = categories
C2:C20 = inventory value

Enter this formula in D2 and copy down as needed:

=SUMPRODUCT(--(A$2:A$20=A2),--(C2<C$2:C$20))+1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RANK based on result and average 5
using RANK function 1
Rank based on 2 categories 6
Rank Function Help Needed 7
duplicate rank issue 2
RANKING alters when data is filtered 4
How to Rank Name? 4
rank 2

Top