Rank Formula

[Andy Stringer]

Hi Guy's.
I have posted this problem because I can not figure how to solve it. I need to string three ranking formula together to result in the correct order. I am not sure if it is possible to do as every thing I have tried does not give me the correct result.
I have posted a copy of a sheet hoping it will explain how it must work.

 

[Mike86]

Please see the attached file.

I'm not sure on how you're evaluating the T:E Ratio. A 230 value should beat out the 135 or 53, but not a 0.

The uploaded file should mimic what you have above. You can delete columns E-G, I just was using them to see how the individual rankings were coming out. If you hit F9, the random values I used for data will regenerate.

 

[Andy Stringer]

Thanks for the reply Mike,
Just a question, can I auto update the figures from another sheet without breaking the formula behind the cells, also is there a reason why when I type anywhere on the sheet it changes the content of the cells it is like the whole sheet is active.
Thank you again.

 

[Mike86]

Just delete all the entries in Columns B and C. Shouldn't hurt anything although the ranking cells will show "#N/A". Type your data in and everything will work.

The numbers are changing because the random number generators in Col B and C kicks out new numbers with any change to the sheet. It's annoying if you're typing, but a fast way of seeing how the setup works with different numbers.

You'll need to update the ranges in Cols H and J if you use more or fewer reviewers. Moving Cols H and J could cause problems, just make sure the references get changed to the columns you're using.

If you have problems, just post your sheet and it'll be easy to review.