Multiple Ranks

Hello again all,

I have an Excel sheet with 4 areas of performance with formulas (Ranks) for each person in my department. I have a need to take each of those ranks I have and make 1 final rank in another column. Example:

I have 114 people in column A, B is metric 1 that was ranked already, C is metric 2 that was ranked already, D is metric 3 that was ranked already, and E is metric 4 that was ranked already. What I need is column F is a final rank for all 114 people. Any ideas on a formula I could use?

Thank you for any help you can provide.

Can't you just add columns B to E in a helper column and then apply a rank to that column?

Hope this helps.

Pete

Yes, this worked perfectly. I just hid column F, and made a rank based off the total. Thank you.