I have a spreadsheet of football statistics organized by team and by postiion. In another workbook is a database. I am trying to pull a line of stats based on team and by most points. For example, "QB1" should equal the statistics for the player from team "Ari" with position "qb" with the most points from the team, QB2 with the second most points, and so on.
Book2.xls | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | Team | POS | G | GS | Comp | ATT | PassYD | PassTD | Int | Rush | RushYD | RushTD | Rec | RecYD | RecTD | Pts | ||
2 | Ari | QB1 | ||||||||||||||||
3 | Ari | QB2 | ||||||||||||||||
4 | Ari | RB1 | ||||||||||||||||
5 | Ari | RB2 | ||||||||||||||||
6 | Ari | RB3 | ||||||||||||||||
7 | Ari | TE1 | ||||||||||||||||
8 | Ari | TE2 | ||||||||||||||||
9 | Ari | WR1 | ||||||||||||||||
10 | Ari | WR2 | ||||||||||||||||
11 | Ari | WR3 | ||||||||||||||||
12 | Ari | WR4 | ||||||||||||||||
Sheet1 |
Book2.xls | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | Team | Position | G | GS | Comp | ATT | PassYD | PassTD | Int | Rush | RushYD | RushTD | Rec | RecYD | RecTD | Pts | ||
2 | min | qb | 16 | 0 | 379 | 548 | 4717 | 39 | 11 | 89 | 406 | 2 | 0 | 0 | 0 | 433 | ||
3 | ind | qb | 16 | 0 | 336 | 497 | 4557 | 49 | 10 | 25 | 38 | 0 | 0 | 0 | 0 | 418 | ||
4 | phi | qb | 15 | 0 | 300 | 469 | 3875 | 31 | 8 | 41 | 220 | 3 | 0 | 0 | 0 | 350 | ||
5 | nyg | te | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 891 | 7 | 89 | ||
6 | atl | te | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65 | 877 | 5 | 88 | ||
7 | jac | rb | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 151 | 575 | 4 | 10 | 65 | 0 | 88 | ||
8 | stl | wr | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 1 | 60 | 801 | 6 | 87 | ||
9 | bal | te | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 75 | 855 | 7 | 86 | ||
10 | den | wr | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 84 | 0 | 42 | 770 | 1 | 85 | ||
11 | nyj | wr | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 73 | 845 | 5 | 85 | ||
12 | dal | wr | 16 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 3 | 0 | 71 | 839 | 6 | 84 | ||
13 | buf | wr | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 81 | 816 | 4 | 82 | ||
14 | tb | rb | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 70 | 436 | 1 | 36 | 300 | 1 | 80 | ||
Sheet2 |