ANTONPRINSLOO
New Member
- Joined
- Jan 2, 2018
- Messages
- 6
NAME | NUMBER | WEIGHT | POINTS | RANK | |
JOHN | 1 | 0.5 | 15 | 5 | |
PETER | 5 | 5.0 | 100 | 1 | |
GERRY | 6 | ||||
CHARLES | 2 | 4 | 60 | 2 | |
TANK | 3 | 6 | 50 | 3 | |
BILL | 1 | 3 | 40 | 4 | |
1ST PLACE | 2ND | 3RD | |||
NAME? | NAME? | NAME? |
<tbody>
</tbody>
please assist me with a formula to get the 1st, 2nd and 3rd place players name in a new block.
COLOM D CONTAINS A FORMULA TO GET TO POINTS. COLOM E CONTAINS A FORMLA O GET TO RANK.
I AM LOOKING FOR A FORMULA TO GET THE NAMES FOR 1st, 2nd and 3rd place players IN A SEPERATE BLOCK ON ANOTHER SHEET.