Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
golf handicap 4 of last 5 scores | Excel Discussion (Misc queries) | |||
Finding the top ten scores | Excel Discussion (Misc queries) | |||
Calculating average scores from multiple sheets' information | Excel Worksheet Functions | |||
Football Scores | Excel Discussion (Misc queries) | |||
Golf Handicap Using Last 5 Scores | Excel Worksheet Functions |