Forum Discussion
Data ranking depend on multiple columns
I have twenty teams of data with three columns of data "uncapped", "Capped" and "Mission, I am trying to ranking twenty teams ranked by:
Capped
if value of different Capped is equal then using the value of Uncapped
If value of different Uncapped is equal then using the value of Missions
If Capped and Uncapped and Missions equal then alphabetically.
Please find the attached.
2 Replies
In this case, use a RANK and 2x SUMPRODUCT.
=RANK(P2,$P$2:$P$21)+SUMPRODUCT(--(P2=$P$2:$P$21),--(Q2<$Q$2:$Q$21))+SUMPRODUCT(--(Q2=$Q$2:$Q$21),--(R2<$R$2:$R$21))HI Tinnkeeper,
After putting your equation the ranking is repeated (i.e same ranking in different row),Please find the attached.
