Well I gave it try and it only showed one player and one stat not sure how
you say it shows the top 5.

I would need it to show the top 3 players in points and the 8 columns of
stats. Player first & last name are in two columns with the rest listed below
as one column each.


Example:
Pos Team Goals Assists +/- Points
1. Joe Sakic LW BUF 3 5 9 17
2. Ron Wilson D CGY 5 5 4 14
3. Don Williams RW SJ 4 4 4 12

Let me put out I don't know too much about formulas... so any help would be
appreciated.



"Biff" wrote:

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