C
coolblueshot
Greetings,
I need some help in creating a function.
Example:
A B
1 John 25
2 Mary 50
3 Tim 35
4 Todd 15
5 Nicole 5
6 Kathy 75
7 Nic 25
8 Justin 100
9 Harley 125
10 Mercedes 125
I need a function that will find the top 5 highest scores from column B
and return the corresponding name from column A. In the above example,
it should return Merceds, Harley, Justin, Kathy, Mary.
Can someone help? Thanks!
I need some help in creating a function.
Example:
A B
1 John 25
2 Mary 50
3 Tim 35
4 Todd 15
5 Nicole 5
6 Kathy 75
7 Nic 25
8 Justin 100
9 Harley 125
10 Mercedes 125
I need a function that will find the top 5 highest scores from column B
and return the corresponding name from column A. In the above example,
it should return Merceds, Harley, Justin, Kathy, Mary.
Can someone help? Thanks!