View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default Listing top three leaders

See this:

http://tinyurl.com/yfd5t9

It's for a top 5 but you should be able to adapt it easily for your needs.

Biff

"Killer" wrote in message
...
I have worksheet that has over 2000 players name and stats... What I want
it
to list the top thee point leaders by there stats in separate column.

A B Ga Assists +/- Ponits
9 Name 1 Last Name 1 7 6 7 20
10 Name 2 Last Name 2 9 10 7 26
11 Name 3 Last Name 3 7 14 10 31
12 Name 4 Last Name 4 42 12 4 56

The resulte would be as followed:
1. Name 4 Last Name 4 42 12 4 56
2. Name 3 Last Name 3 7 14 10 31
3. Name 2 Last Name 2 9 10 7 26

thanks ahead