Finding Top N Performers in a list with Multiple Criteria

[reggie n]

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

 

[reggie n]

Did I make the problem clear?

 

[reggie n]

bump

 

[reggie n]

bump