| A | B | C | D | E | F | |
| 1 | Name | Score | Rank | Score | Name | |
| 2 | Player A | 1 | 1 | 5 | Player E | |
| 3 | Player B | 2 | 2 | 4 | Player D | |
| 4 | Player C | 3 | 3 | 3 | Player C | |
| 5 | Player D | 4 | Player H | |||
| 6 | Player E | 5 | 4 | 2 | Player B | |
| 7 | Player F | 1 | Player G | |||
| 8 | Player G | 2 | 5 | 1 | Player A | |
| 9 | Player H | 3 | Player F |
<tbody>
</tbody>
hye mate...i have small problem with ranking...base on score....
please help me if u understand.....the empty cell and D5,E5,D7,E7, D9 & E9....
please help me to get formula for D, E and F...tQ
