adurham22926192
New Member
- Joined
- Dec 17, 2019
- Messages
- 49
- Office Version
- 2019
- Platform
- Windows
Hi I have the competitor numbers in column A (A1: 101, A2:108 etc) and their score in column B (B1: 87.00, B2: 84.00) and i need a formula for C1 to look up the highest score in the column B and return the competitors number, and so on so look up the second largest score and return the competitors number.
Please help thanks so much
Please help thanks so much