How to find top positions basis multiple criteria while handling ties

[ravi123]

Hello All,
I'm looking for excel formula for following set of data:

I'm having Names in Col A, Scores in column B and quantity lifted in Col C.
I need to find top 3 positions. First data needs to be scan through Col B and find highest score and if there is a tie, than Col C should be considered and find the highest quantity lifted, this will be consider at no. 1 position, same logic will be applied to next highest score and quantity lifted if there is a tie.
There is a catch for third position, third position will be share by two candidates.
If there is no tie in scores than it may straight determine positions.
Col D will be having positions and Col E will be having corresponding Names of winners

Sample data and output mentioned below. Any help will further save my further hours of searching. Thanks

Name	Scores	Quantity		Position	Winners
A	10​	50​		1​	D
B	30​	85​		2​	F
C	30​	70​		3​	B
D	60​	150​		3​	H
E	60​	140​
F	40​	100​
G	40​	90​
H	30​	71​

 

[Anthony47]

Use col D as help column:
Call it "Points"; in D2 use the formula

=B2+C2/1000-ROW()/100000

Copy the formula down
Now in F2 set the formula

=INDEX($A$1:$A$10,MATCH(LARGE($D$1:$D$10,E2);$D$1:$D$10,0))

Copy the formula down for as many lines have a position in coloumn E (Position)

In this way the Rank will be determined, in descending order of importance, by the Score (column B), by the Quantity (column C), and by the position in the table
Bye

 

[Fluff]

@ravi123
What version of Excel are you using?
Please update your account details to show, as it affects which functions you can use.

Also why is the order D, F, B, H? shouldn't it be D, E, F, G?