Ranking (weighted) issue

**jw01** · 09-07-2011, 11:35 AM

Hello

having some trouble trying to rank different criterias on percentages

bascially, i have different metrics for sales ppl i.e. KPI NAR, i would that to be 30%

i have attached a sample workbook with the outlined sample percentages, however im not sure how to rank based on percentages?

so for example

KPI NAR
john doe $300
is it simply $300 * 30% * rank(A1,B1:B4,0)
*this is just a made up example*

can someone pls help!

**ChemistB** · 09-07-2011, 11:49 AM

How about this;
In N6 "Overall Score"
In N7 dragged down =E7*$D$5+G7*$F$5+I7*$H$5+K7*$J$5+M7*$L$5
In O6 "Overall Rank"
In O7 dragged down =RANK(N7,$N$7:$N$21,1)
Does that work for you?

**jw01** · 09-07-2011, 03:33 PM

hey thxs bud

that does the trick....is it possibly and does it make sense to rank each category by the percentage? i.e. is there a quick way w.o having to create extra columns if i wanted to rank the KPI revenue column E using the weighted rank?

thxs alot!!!!

**ChemistB** · 09-07-2011, 03:50 PM

I'm not following. Column N weighs the different catagories by the percentages. If you just looked at KPI based on the fact it's "worth" 30% of all catagories, you are still just looking at KPI (times 30%) and you'll get the same ranking.