Rank Function with Multiple Criteria
Sounds like you want a "weighted average". Multiply each ranking by its
percentage weight and then add them up.
Rick
"KellyC" wrote in message
...
I am trying to Rank 5 different criteria for 28 employees. I am currently
ranking each criteria as a seperate column within each category; however,
I
need to roll up all of the rankings to another page and have a Power
Ranking
per employee. The Power Ranking was working as an AVERAGE function until
the
percentages of the categories were not an equal 20%. Can anyone help?
Thank you!
|