bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
Hello
I have the following rank formula in place for KPI Revenue for my sales team.
RANK(E12,$E$12:$E$75,0)
I have 15 other metrics that I track (KPI Revenue, calls,deals sold etc).
I would like to rank it based on percentage i.e.
KPI Revenue to be 30%
# of deals 20%
all others to be 50%
how would i do that, is there an excel formula? or is it just
RANK(E12,$E$12:$E$75,0)*30%
when i try that, my rank goes 0-10 with alot of multiple rankings i.e. 0, 1, 1, 1, 2, 2, 3, 3, 3, etc
can someone pls help!
I have the following rank formula in place for KPI Revenue for my sales team.
RANK(E12,$E$12:$E$75,0)
I have 15 other metrics that I track (KPI Revenue, calls,deals sold etc).
I would like to rank it based on percentage i.e.
KPI Revenue to be 30%
# of deals 20%
all others to be 50%
how would i do that, is there an excel formula? or is it just
RANK(E12,$E$12:$E$75,0)*30%
when i try that, my rank goes 0-10 with alot of multiple rankings i.e. 0, 1, 1, 1, 2, 2, 3, 3, 3, etc
can someone pls help!