Split the prize amounts for ties?

[Douglas Edward]

How do I create a formula to split the prize amounts for ties? (It's for a golf league)

Player Score Rank Prize Rank Prize In this example the prize payout should be…
A 70 1 ? 1 100 95
B 70 1 ? 2 90 95
C 71 3 ? 3 80 70
E 71 3 ? 5 60 70
F 72 6 ? 6 50 30
G 72 6 ? 7 40 30
H 72 6 ? 8 30 30
I 72 6 ? 9 20 30
J 72 6 ? 10 10 30

 

[kvsrinivasamurthy]

Player	score	rank	prize	rank	prize
A	70	1	95	1	100
B	72	5	40	2	90
C	72	5	40	3	80
E	71	3	75	4	70
F	72	5	40	5	60
G	70	1	95	6	50
H	71	3	75	7	40
I	72	5	40	8	30
J	72	5	40	9	20
K	73	10	10	10	10

<tbody>
</tbody>

Formula in C2

=RANK(B2,$B$2:$B$11,1)

Formula in D2

=SUMPRODUCT(($F$2:$F$11)*($E$2:$E$11>=C2)*($E$2:$E$11<(C2+COUNTIF($C$2:$C$11,C2))))/COUNTIF($C$2:$C$11,C2)

Both formulas dragged down.

 

[Douglas Edward]

That works perfectly! Thank you Marcelo. You da Man!

 

[Douglas Edward]

Thanks kvsrinivasamurthy! I just tried yours. It Works perfectly too!

I guess I can use either one, since they both work. Time to flip a coin. ha

Thanks guys!