Graham C1600
Board Regular
- Joined
- Feb 17, 2018
- Messages
- 96
- Office Version
- 365
Hi,
Suppose I have a list as per below :-
<tbody>
</tbody>
In my actual excel the list is much larger but I hope you get what I'm trying to achieve.
So in cell G1 for instance I want to show the top 5 numbers from column b starting with the largest and coming down, but I need it so show column A & B. So it would look something like this :-
<tbody>
</tbody>
Then again in Cell I1 I want the top 10% of Column B to be displayed as above. Then in cell K1 I want a formula to list the top 5 based on a number I want to put into the formula.
Hope this makes sense.
Thanks in advance.
Suppose I have a list as per below :-
A | B | C | D | E |
Graham | 1 | 12 | 5 | 12 |
Simon | 1 | 32 | 4 | 332 |
Richard | 4 | 43 | 6 | 23 |
Brendan | 6 | 12 | 34 | 45 |
Sarah | 8 | 45 | 77 | 33 |
Stephen | 5 | 32 | 43 | 45 |
Taylor | 3 | 45 | 23 | 66 |
Mark | 2 | 34 | 56 | 77 |
Andrew | 9 | 67 | 23 | 88 |
<tbody>
</tbody>
In my actual excel the list is much larger but I hope you get what I'm trying to achieve.
So in cell G1 for instance I want to show the top 5 numbers from column b starting with the largest and coming down, but I need it so show column A & B. So it would look something like this :-
Andrew | 9 |
Sarah | 8 |
Brendan | 6 |
Richard | 4 |
Taylor | 3 |
<tbody>
</tbody>
Then again in Cell I1 I want the top 10% of Column B to be displayed as above. Then in cell K1 I want a formula to list the top 5 based on a number I want to put into the formula.
Hope this makes sense.
Thanks in advance.