It can be kind of invovled. A top 3 list could be more than 3 when you
consider ties. For example:

Most HR's

10
10
10
10
8
8
8
7
7
7
7

In this case your top 3 is actually 11.

I'll put together a sample file later this evening when I have more time.


--
Biff
Microsoft Excel MVP


"Confused at Work" wrote in
message ...
If you know how ot do the information then we could do the top three
players
in all statistics..

"T. Valko" wrote:

What should happen if more than one player leads in a particular
category?
For example, both player 14 and 7 have 10 HRs.

--
Biff
Microsoft Excel MVP


"Confused at Work" wrote in
message ...
Looking to do a baseball spreadsheet to keep track of my teams progress
in
the upcoming season.

A B C D
E F
1 NAME 14 1 6
#7
NAME
2 NAME 57 3
3 NAME 13 5
4 NAME 7 6
5 NAME 11 2
THERES MY CHART WHAT IT LOOKS LIKE SO FAR, PLAYER NAMES, PLAYER JERSEY
NUMBERS, AND THEIR STATS, SINGLES, DOUBLES, HOE RUNS... ETC... I WANT
ON
ANOTHER SECTION OF THE PAGE UPDATE THE INFORMATION TO WHO HAS THE MOST
SINGLES OR DOUBLES ETC, I WAN TTHEIR NAME AND THEN IN A SEPERATE CELL
THEIR
STAT. i CAN GET THEIR STAT OVER THERE THE HIGHEST, BUT I WANT THEIR
NAME
OVER THERE TOO.... PLEASE HELP ME.