Formula to rank all results but two columns results

[tonywatsonhelp]

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

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

 

[jimrward]

One way is create a helper column which is score + (rating/1000) and rank on that new column
so you get 24.333, 20.757, 20.232, 20.111 etc

 

[tonywatsonhelp]

Excellent Idea,
new there would be a simple one i just could not think of it,
Thanks very much Jim

 

[jimrward]

It’s just one solution
if you have a second tie breaker you can also add it in but you need to divide that by a higher number
score + (tb1/1000) + (tb2/1000000)
I only chose 1000 because your numbers were high, it get a little bit trickier if one of the tie breaks is lowest value then you might have to look at ((1000-tb3)/1000) etc