:cool:Team Leaders

[justpete]

Hi, I have the following spreadsheet. All I'm trying to do is list the 3 top players from each column on a separate sheet. What's the simplest way to do that? I tried Advanced filtering, but always get an error. I also tried a number of the formula solutions on here, but haven't had any luck. Can anyone help?

/ps, hope this formatting works!

Name Total AB AB R H 1B 2B 3B HR RBI BB HB K SB SF AVG OBA SLG
Jim I 12 7 4 6 5 0 0 1 5 3 0 0 1 2 0.857 0.900 1.286
Arif P 16 15 5 10 9 0 0 1 8 1 0 1 0 0 0.667 0.688 0.867
Mike T 14 14 6 9 8 1 0 0 0 0 0 0 2 0 0.643 0.643 0.714
Mike F 16 15 3 7 5 2 0 0 1 1 0 4 2 0 0.467 0.500 0.600
Scott M 15 13 7 6 2 3 0 1 8 2 0 1 4 0 0.462 0.533 0.923
Paul M 13 11 0 5 4 1 0 0 3 1 1 0 1 0 0.455 0.538 0.545
Chris P 16 16 3 7 6 0 0 1 4 0 0 0 0 0 0.438 0.438 0.625
Dale W 16 13 4 5 3 0 0 2 6 3 0 2 0 0 0.385 0.500 0.846
Andy H 15 13 5 5 2 2 1 0 3 2 0 2 7 0 0.385 0.467 0.692
Ryan S 15 12 6 3 2 1 0 0 2 2 1 1 0 0 0.250 0.400 0.333
Peter F 7 5 1 1 1 0 0 0 1 2 0 3 0 0 0.200 0.429 0.200
Steve H 15 11 3 2 1 1 0 0 3 4 0 0 2 0 0.182 0.400 0.273
Paul B 14 12 3 2 2 0 0 0 1 2 0 3 0 0 0.167 0.286 0.167
Joe F 16 15 1 2 2 0 0 0 3 1 0 1 0 0 0.133 0.188 0.133
Red Sox Team 200 172 51 70 52 11 1 6 48 24 2 18 19 0.407 0.485 0.621

 

[Phox]

When you enter via the menu, it needs to be like this

=Sheet1!$A$2:$A$15

The easier way to define the range is to highlight the range and then type the name in the box directly above the Column A label.

 

[justpete]

When you enter via the menu, it needs to be like this

=Sheet1!$A$2:$A$15

The easier way to define the range is to highlight the range and then type the name in the box directly above the Column A label.

Thanks so much for your patience, Phox! Now I just need to modify it slightly for the 10 other stats!