adurham22926192
New Member
- Joined
- Dec 17, 2019
- Messages
- 49
- Office Version
- 2019
- Platform
- Windows
A | B | C | D | E | F | G | H | |
1 | Number | Total Marks | Points Awarded | Rank | 9 | Number | Total Marks | Points Awarded |
2 | 163 | 99 | 100 | 1 | ||||
3 | 193 | 98 | 49 | 2 | ||||
4 | 156 | 97 | 24 | 3 | ||||
5 | 98 | 94 | 8.5 | 4 | ||||
6 | 179 | 94 | 8.5 | 4 | ||||
7 | 62 | 93 | 5 | 6 | ||||
8 | 96 | 92 | 4 | 7 | ||||
9 | 95 | 90.5 | 3 | 8 | ||||
10 | 155 | 89.5 | 2 | 9 | ||||
11 | 101 | 80 | 1 | 10 | ||||
12 | 105 | 70 | 0 | 11 |
In Column A is the competitor number.
in Column B is the total marks they received
in column C is the points they were awarded
cooumn d is the rank
basically, i want to show the top nth number of results in columns f to h Based on the number that is in cell E1. In E1, it says 9 so in columns f to h I want the data from a2:c10 to show up as they are the top 9 competitors. But if the number in E1 was 8, I only want the top 8 competitors to show up in F:H. I hope this makes sence! Thanks