LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Top 5 Scores

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
golf handicap 4 of last 5 scores Golf.nut1 Excel Discussion (Misc queries) 15 April 3rd 08 06:11 AM
Finding the top ten scores JeffShone Excel Discussion (Misc queries) 2 February 16th 06 12:38 PM
Calculating average scores from multiple sheets' information quailhunter Excel Worksheet Functions 2 October 16th 05 10:37 PM
Football Scores Number_8 Excel Discussion (Misc queries) 4 August 12th 05 05:46 PM
Golf Handicap Using Last 5 Scores Golf League Schedule Excel Worksheet Functions 5 May 13th 05 12:14 AM


All times are GMT +1. The time now is 01:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"