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
Try
=IFERROR(RANK(L7,$L$7:$L$18),"")
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Im sorry but you'll need to explain that function. Where does it go? What does it do?
It replaces the one you currently have.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
Posting Permissions
Reply With Quote
