How To Auto-move Players In Cup Tree Using Formulas

I am trying to build a cup tree that automaticly move players over to the next round if they are first or second in
their group of 4. What happens when first person have a result of lets say 33 and 2nd and 3d person have a result of 35 each and the 4th person 37? First person is easy but then there are 2 persons with the sam result and they play sudden death and we put in a 1 in the sd column for the winner and a 2 for the loser of the sudden death.

How do I make my formula figure that if they had the same result go look at the sd column?

Another thing is that of the 2 players advancing they have to be placed in the same order in next round, how can I achieve that?

If you look in column I row 19-22 there are players in the wrong order because the player with the better result goes in first. It should be this order: 9 11 15 16 instead. (if you are ahead in the previous round you will be ahead in the next round)

Another problem I noticed now is that when 2 players has the same lowest score the first player takes both spots as it is now and that doesn't work in real. You see what I mean if you look at player 1 in round 1 and 2 (R1 & R2), in this case it should have been players 1 2 6 and 7 moving on to round 2 and not 1 1 6 7 as it is at the moment.

(Rank is their rank from the qulification rounds where the first 4 is seeded and the rest is drawn into 1 group a time)

Klass B

*
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R

2
Rank
Name
R1
sd
Pl.

[Code] .......

Spreadsheet Formulas

Cell
Formula

I7
=IF('Klass B Calculations'!F4=1;'Klass B Calculations'!C4;IF('Klass B Calculations'!F5=1;'Klass B Calculations'!C5;
IF('Klass B Calculations'!F6=1;'Klass B Calculations'!C6;IF('Klass B Calculations'!F7=1;'Klass B Calculations'!C7;""))))

[Code] ..........