tonywatsonhelp
Wellknown Member
 Joined
 Feb 24, 2014
 Messages
 2,727
 Office Version

 365
 2019
 2016
 Platform

 Windows
Hi Everyone,
I was wonder how to do this,
its our end of year staff awards show, we have had quizes etc durring the year and now we have the results,
so i need to work out how to quickly workout the order everyone has come,
its quite simple i just dont knoe how to do it,
its like this
16 names two columns for results
Score and rating
so highest score wins, down to lowest score,
but when two or more get the same score we use rating to decide who wins,
so all i need is a formula to give me the order everyone has come in?
the table bellow explains
I was wonder how to do this,
its our end of year staff awards show, we have had quizes etc durring the year and now we have the results,
so i need to work out how to quickly workout the order everyone has come,
its quite simple i just dont knoe how to do it,
its like this
16 names two columns for results
Score and rating
so highest score wins, down to lowest score,
but when two or more get the same score we use rating to decide who wins,
so all i need is a formula to give me the order everyone has come in?
the table bellow explains
Name  Result  Score  If i use RANK i get something like this  Number? (this is what im trying to get  
Bob  111  20  2  4  
sue  222  15  6  7  
Tom  333  24  so 24 is highest  1  1 
Sally  232  20  2  3  
Jonh  757  20  2  2  
Jim  121  17  5  5  
Jem  234  15  6  6  
Len  55  10  10 is lowest  8  8 
so i cant have 3 = "2" and 2="6" so we need to then rank these by the higest Result like above 