Ranking formula with a subset with a column

Tansohn

New member
Joined
Dec 16, 2015
Messages
4
Reaction score
0
Points
0
I am trying to rank a column of data within a subset of the dat. I have attached a sample sheet but here is what I want to do

Column A is a Sku number, Column B is a total $ amount for the sku and Column C is a color

I want to add a formula to rank the dollar amounts based on the color

Any ideas are appreciated
 

Attachments

  • Stack Rank Sample.xlsx
    10.8 KB · Views: 8
In D2:
=1+SUMPRODUCT(($C$2:$C$83=C2)*($B$2:$B$83>B2))
and copy down.
(also in attached)
 

Attachments

  • ExcelGuru7247Stack Rank Sample.xlsx
    18.7 KB · Views: 4
Last edited:
Back
Top