Formula Problem

[Confused at Work]

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.

 

[T. Valko]

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

 

[Confused at Work]

If you know how ot do the information then we could do the top three players
in all statistics..

 

[T. Valko]

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.

 

[T. Valko]

Ooops!

Sorry, I forgot all about this thread!

Ok, here's the sample file that demonstrates this.

xTopN.xls 18kb

http://cjoint.com/?elxqEIRIRX

I've used named ranges in the formulas. The formula in column H is an array
formula**. You'll notice that even though you want the top 3 there are 5
players list. This is due to ties.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)