PDA

View Full Version : [SOLVED] Team ranking not working



worthm
02-02-2015, 04:39 PM
Hello, I use Office 2010. I was given some Excel coding to rank my team based on five metrics. The ranking is supposed to give one overall number rank to each employee based on the five variables. See attached. I cant get the ranking to work. Can someone take a look and provide a fix?

Also, is there a way to ignore any row which has a divided by error? I need to add new hires who don't yet have some of the scores so I need to ignore them until they have scores in all fields

Thanks for any help

Bob Phillips
02-03-2015, 03:11 AM
Try

=IFERROR(RANK(L7,$L$7:$L$18),"")

worthm
02-03-2015, 08:23 AM
Im sorry but you'll need to explain that function. Where does it go? What does it do?

Bob Phillips
02-03-2015, 03:11 PM
It replaces the one you currently have.

worthm
02-04-2015, 02:53 PM
I found a fix for this on another website. I've attached the corrected version here. The fix is in each cell in columns I and L