Multiple with same %, need 2nd & 3rd

[gtd526]

Hello,
If you have multiple of the same % (T:T), how do you retrieve the 2nd and 3rd name (S:S) of the same %?
Looking to fill S:S.
Im using the following:
thank you

Wagers.xlsm
	S	T	U
7	Team	MAX	Count %
8	MIA	100%	2
9	MIA	100%	2
10	LAL	75%	3
11	LAL	75%	3
12	LAL	75%	3
13	BOS	67%	3
14	BOS	67%	3
15	BOS	67%	3
16	TOR	50%	3
17	TOR	50%	3
18	TOR	50%	3
NBA

Cell Formulas
Range	Formula
S8:S18	S8	=INDEX($N$7:$N$36,MATCH(T8,$Q$7:$Q$36,0),1)
T8	T8	=MAX($Q$7:$Q$36)
U8:U18	U8	=COUNTIF($Q$7:$Q$36,T8)
T9	T9	=LARGE($Q$7:$Q$36,2)
T10	T10	=LARGE($Q$7:$Q$36,3)
T11	T11	=LARGE($Q$7:$Q$36,4)
T12	T12	=LARGE($Q$7:$Q$36,5)
T13	T13	=LARGE($Q$7:$Q$36,6)
T14	T14	=LARGE($Q$7:$Q$36,7)
T15	T15	=LARGE($Q$7:$Q$36,8)
T16	T16	=LARGE($Q$7:$Q$36,9)
T17	T17	=LARGE($Q$7:$Q$36,10)
T18	T18	=LARGE($Q$7:$Q$36,11)

 

[Fluff]

Can you also post the data from columns N & Q

 

[gtd526]

Can you also post the data from columns N & Q

Can you also post the data from columns N & Q

Here are the columns you wanted to see.
Also want to make sure the Counts (U:U) are correct.
Everything in S,T,U.

Wagers.xlsm
	N	O	P	Q	R	S	T	U
6	Team	W	L	W %		Team	MAX	Count %
7	SAC	0	0			ATL	100%	2
8	BOS	2	1	67%		ATL	100%	2
9	MIL	3	6	33%		PHX	75%	2
10	CHA	3	1	75%		CHA	75%	3
11	ATL	1	0	100%		BOS	75%	3
12	UTA	4	2	67%		BOS	67%	3
13	GS	2	1	67%		BOS	67%	4
14	MEM	1	1	50%		BOS	67%	3
15	OKC	0	2	0%		MEM	50%	3
16	LAC	1	3	25%		MEM	50%	3
17	PHX	3	1	75%		MIL	50%	3
18	WAS	0	2	0%		MIL	33%	1
19	BRK	1	1	50%		OKC	33%	1
20	IND	0	2	0%		OKC	0%	8
21	CHI	0	1	0%		OKC	0%	8
22	DEN	0	2	0%		OKC	0%	8
23	LAL	3	1	75%		OKC	0%	7
24	MIN	0	1	0%		OKC	0%	8
25	TOR	2	2	50%		OKC	0%	8
26	MIA	2	0	100%		OKC	0%	8
27	ORL	0	1	0%		OKC	0%	8
28	HOU	0	1	0%		OKC	0%	8
29	DAL	0	1	0%		OKC	0%	9
30
31
NBA

Cell Formulas
Range	Formula
O7:O29	O7	=COUNTIFS($A$3:$A$1000,"W",$H$3:$H$1000,N7)
P7:P29	P7	=COUNTIFS($A$3:$A$1000,"L",$H$3:$H$1000,N7)
S7:S29	S7	=INDEX($N$7:$N$36,MATCH(T7,$Q$7:$Q$36,0),1)
T7	T7	=MAX($Q$7:$Q$36)
U7:U29	U7	=COUNTIF($Q$7:$Q$30,T7)
T8	T8	=LARGE($Q$7:$Q$36,2)
T9	T9	=LARGE($Q$7:$Q$36,3)
T10	T10	=LARGE($Q$7:$Q$36,4)
T11	T11	=LARGE($Q$7:$Q$36,5)
T12	T12	=LARGE($Q$7:$Q$36,6)
T13	T13	=LARGE($Q$7:$Q$36,7)
T14	T14	=LARGE($Q$7:$Q$36,8)
T15	T15	=LARGE($Q$7:$Q$36,9)
T16	T16	=LARGE($Q$7:$Q$36,10)
T17	T17	=LARGE($Q$7:$Q$36,11)
T18	T18	=LARGE($Q$7:$Q$36,12)
T19	T19	=LARGE($Q$7:$Q$36,13)
T20	T20	=LARGE($Q$7:$Q$36,14)
T21	T21	=LARGE($Q$7:$Q$36,15)
T22	T22	=LARGE($Q$7:$Q$36,16)
T23:T29	T23	=LARGE($Q$7:$Q$36,17)
N7:N31	N7	=IFERROR(LOOKUP(2, 1/((COUNTIF($N$7:N7,$H$3:$H$500)=0)*($H$3:$H$500<>"")),$H$3:$H$500),"")
Q7:Q31	Q7	=IFERROR(O7/(O7+P7),"")

 

[Fluff]

How about

+Fluff 1.xlsm
	N	O	P	Q	R	S	T	U
6	Team	W	L	W %		Team	MAX	Count %
7	SAC	0	0			ATL	100%	2
8	BOS	2	1	67%		MIA	100%	2
9	MIL	3	6	33%		CHA	75%	3
10	CHA	3	1	75%		PHX	75%	3
11	ATL	1	0	100%		LAL	75%	3
12	UTA	4	2	67%		BOS	67%	3
13	GS	2	1	67%		UTA	67%	3
14	MEM	1	1	50%		GS	67%	3
15	OKC	0	2	0%		MEM	50%	3
16	LAC	1	3	25%		BRK	50%	3
17	PHX	3	1	75%		TOR	50%	3
18	WAS	0	2	0%		MIL	33%	1
19	BRK	1	1	50%		LAC	25%	1
20	IND	0	2	0%		SAC	0%	9
21	CHI	0	1	0%		OKC	0%	9
22	DEN	0	2	0%		WAS	0%	9
23	LAL	3	1	75%		IND	0%	9
24	MIN	0	1	0%		CHI	0%	9
25	TOR	2	2	50%		DEN	0%	9
26	MIA	2	0	100%		MIN	0%	9
27	ORL	0	1	0%		ORL	0%	9
28	HOU	0	1	0%		HOU	0%	9
29	DAL	0	1	0%
Main

Cell Formulas
Range	Formula
S7:S28	S7	=INDEX($N$6:$N$35,AGGREGATE(15,6,(ROW($N$6:$N$35)-ROW($N$6)+1)/($Q$6:$Q$35=T7),COUNTIFS(T$7:T7,T7)))
T7:T28	T7	=LARGE($Q$6:$Q$35,ROWS(T$7:T7))
U7:U28	U7	=COUNTIF($Q$6:$Q$35,T7)

 

[gtd526]

How about

+Fluff 1.xlsm
	N	O	P	Q	R	S	T	U
6	Team	W	L	W %		Team	MAX	Count %
7	SAC	0	0			ATL	100%	2
8	BOS	2	1	67%		MIA	100%	2
9	MIL	3	6	33%		CHA	75%	3
10	CHA	3	1	75%		PHX	75%	3
11	ATL	1	0	100%		LAL	75%	3
12	UTA	4	2	67%		BOS	67%	3
13	GS	2	1	67%		UTA	67%	3
14	MEM	1	1	50%		GS	67%	3
15	OKC	0	2	0%		MEM	50%	3
16	LAC	1	3	25%		BRK	50%	3
17	PHX	3	1	75%		TOR	50%	3
18	WAS	0	2	0%		MIL	33%	1
19	BRK	1	1	50%		LAC	25%	1
20	IND	0	2	0%		SAC	0%	9
21	CHI	0	1	0%		OKC	0%	9
22	DEN	0	2	0%		WAS	0%	9
23	LAL	3	1	75%		IND	0%	9
24	MIN	0	1	0%		CHI	0%	9
25	TOR	2	2	50%		DEN	0%	9
26	MIA	2	0	100%		MIN	0%	9
27	ORL	0	1	0%		ORL	0%	9
28	HOU	0	1	0%		HOU	0%	9
29	DAL	0	1	0%
Main

Cell Formulas
Range	Formula
S7:S28	S7	=INDEX($N$6:$N$35,AGGREGATE(15,6,(ROW($N$6:$N$35)-ROW($N$6)+1)/($Q$6:$Q$35=T7),COUNTIFS(T$7:T7,T7)))
T7:T28	T7	=LARGE($Q$6:$Q$35,ROWS(T$7:T7))
U7:U28	U7	=COUNTIF($Q$6:$Q$35,T7)

Looks good with your spreadsheet, but here are my results using your formulas:

Wagers.xlsm
	N	O	P	Q	R	S	T	U
6	Team	W	L	W %		Team	MAX	Count %
7	SAC	0	0			ATL	100%	2
8	BOS	2	2	50%		MIA	100%	2
9	MIL	3	6	33%		#NUM!	75%	2
10	CHA	4	1	80%		LAL	75%	2
11	ATL	1	0	100%		GS	75%	2
12	UTA	4	2	67%		UTA	67%	2
13	GS	2	1	67%		BOS	67%	3
14	MEM	1	1	50%		BOS	50%	4
15	OKC	0	2	0%		MEM	50%	4
16	LAC	1	3	25%		BRK	50%	4
17	PHX	3	1	75%		MIL	50%	4
18	WAS	0	2	0%		MIL	33%	1
19	BRK	1	1	50%		OKC	33%	1
20	IND	0	2	0%		OKC	0%	8
21	CHI	0	1	0%		WAS	0%	8
22	DEN	0	2	0%		IND	0%	8
23	LAL	3	1	75%		CHI	0%	7
24	MIN	0	1	0%		DEN	0%	8
25	TOR	2	2	50%		MIN	0%	8
26	MIA	2	0	100%		HOU	0%	8
27	ORL	0	1	0%		ORL	0%	8
28	HOU	0	1	0%		#NUM!	#NUM!	0
29	DAL	0	1	0%		#NUM!	#NUM!	0
NBA

Cell Formulas
Range	Formula
N7:N29	N7	=IFERROR(LOOKUP(2, 1/((COUNTIF($N$7:N7,$H$3:$H$500)=0)*($H$3:$H$500<>"")),$H$3:$H$500),"")
O7:O29	O7	=COUNTIFS($A$3:$A$1000,"W",$H$3:$H$1000,N7)
P7:P29	P7	=COUNTIFS($A$3:$A$1000,"L",$H$3:$H$1000,N7)
Q7:Q29	Q7	=IFERROR(O7/(O7+P7),"")
S7:S29	S7	=INDEX($N$6:$N$35,AGGREGATE(15,6,(ROW($N$6:$N$35)-ROW($N$6)+1)/($Q$6:$Q$35=T7),COUNTIFS(T$7:T7,T7)))
T7:T29	T7	=LARGE($Q$6:$Q$35,ROWS(T$7:T7))
U7:U29	U7	=COUNTIF($Q$6:$Q$35,T7)

How about

+Fluff 1.xlsm
	N	O	P	Q	R	S	T	U
6	Team	W	L	W %		Team	MAX	Count %
7	SAC	0	0			ATL	100%	2
8	BOS	2	1	67%		MIA	100%	2
9	MIL	3	6	33%		CHA	75%	3
10	CHA	3	1	75%		PHX	75%	3
11	ATL	1	0	100%		LAL	75%	3
12	UTA	4	2	67%		BOS	67%	3
13	GS	2	1	67%		UTA	67%	3
14	MEM	1	1	50%		GS	67%	3
15	OKC	0	2	0%		MEM	50%	3
16	LAC	1	3	25%		BRK	50%	3
17	PHX	3	1	75%		TOR	50%	3
18	WAS	0	2	0%		MIL	33%	1
19	BRK	1	1	50%		LAC	25%	1
20	IND	0	2	0%		SAC	0%	9
21	CHI	0	1	0%		OKC	0%	9
22	DEN	0	2	0%		WAS	0%	9
23	LAL	3	1	75%		IND	0%	9
24	MIN	0	1	0%		CHI	0%	9
25	TOR	2	2	50%		DEN	0%	9
26	MIA	2	0	100%		MIN	0%	9
27	ORL	0	1	0%		ORL	0%	9
28	HOU	0	1	0%		HOU	0%	9
29	DAL	0	1	0%
Main

Cell Formulas
Range	Formula
S7:S28	S7	=INDEX($N$6:$N$35,AGGREGATE(15,6,(ROW($N$6:$N$35)-ROW($N$6)+1)/($Q$6:$Q$35=T7),COUNTIFS(T$7:T7,T7)))
T7:T28	T7	=LARGE($Q$6:$Q$35,ROWS(T$7:T7))
U7:U28	U7	=COUNTIF($Q$6:$Q$35,T7)

Looks good on your end, but here are my results using your formula. Everytime is hit save the results change.

Wagers.xlsm
	N	O	P	Q	R	S	T	U
6	Team	W	L	W %		Team	MAX	Count %
7	BOS	2	2	50%		ATL	100%	2
8	SAC	1	0	100%		ATL	100%	3
9	CHA	4	1	80%		MIA	100%	3
10	MIL	3	6	33%		CHA	80%	1
11	UTA	4	2	67%		#NUM!	75%	2
12	ATL	1	0	100%		LAL	75%	2
13	MEM	1	1	50%		UTA	67%	1
14	GS	2	1	67%		GS	67%	2
15	LAC	1	3	25%		BOS	50%	4
16	OKC	0	2	0%		MEM	50%	4
17	WAS	0	2	0%		BRK	50%	4
18	PHX	3	1	75%		TOR	50%	4
19	IND	0	2	0%		#NUM!	25%	1
20	BRK	1	1	50%		#NUM!	25%	1
21	DEN	0	2	0%		OKC	0%	9
22	CHI	0	1	0%		WAS	0%	9
23	MIN	0	1	0%		IND	0%	10
24	LAL	3	1	75%		DEN	0%	9
25	MIA	2	0	100%		CHI	0%	9
26	TOR	2	2	50%		MIN	0%	9
27	HOU	0	1	0%		HOU	0%	9
28	ORL	0	1	0%		ORL	0%	9
29		0	0			#NUM!	#NUM!	0
30	DAL
NBA

Cell Formulas
Range	Formula
O7:O29	O7	=COUNTIFS($A$3:$A$1000,"W",$H$3:$H$1000,N7)
P7:P29	P7	=COUNTIFS($A$3:$A$1000,"L",$H$3:$H$1000,N7)
S7:S29	S7	=INDEX($N$6:$N$35,AGGREGATE(15,6,(ROW($N$6:$N$35)-ROW($N$6)+1)/($Q$6:$Q$35=T7),COUNTIFS(T$7:T7,T7)))
T7:T29	T7	=LARGE($Q$6:$Q$35,ROWS(T$7:T7))
U7:U29	U7	=COUNTIF($Q$6:$Q$35,T7)
N7:N30	N7	=IFERROR(LOOKUP(2, 1/((COUNTIF($N$7:N7,$H$3:$H$500)=0)*($H$3:$H$500<>"")),$H$3:$H$500),"")
Q7:Q30	Q7	=IFERROR(O7/(O7+P7),"")

 

[Fluff]

Do you have any values below row 30?

 

[gtd526]

Do you have any values below row 30?

No, everything from 31 down are blank.

Wagers.xlsm
	N	O	P	Q	R	S	T	U
6	Team	W	L	W %		Team	MAX	Count %
7	UTA	4	2	67%		ATL	100%	2
8	BRK	1	1	50%		MIA	100%	2
9	SAC	0	1	0%		CHA	80%	1
10	BOS	2	2	50%		PHX	75%	2
11	MIL	3	6	33%		LAL	67%	2
12	CHA	4	1	80%		GS	67%	2
13	ATL	1	0	100%		#NUM!	67%	1
14	GS	2	1	67%		BRK	50%	4
15	OKC	0	2	0%		BOS	50%	3
16	MEM	1	1	50%		MEM	50%	4
17	PHX	3	1	75%		MIL	50%	4
18	LAC	1	3	25%		MIL	33%	1
19	IND	0	2	0%		LAC	25%	1
20	WAS	0	2	0%		SAC	0%	11
21	DEN	0	2	0%		OKC	0%	11
22	CHI	0	1	0%		IND	0%	11
23	MIN	0	1	0%		WAS	0%	12
24	LAL	3	1	75%		DEN	0%	11
25	TOR	2	2	50%		CHI	0%	11
26	MIA	2	0	100%		MIN	0%	11
27	ORL	0	1	0%		ORL	0%	11
28	HOU	0	1	0%		HOU	0%	11
29		0	0			DAL	0%	10
30		0	0			0	#NUM!	0
31
32
33
34
35
NBA

Cell Formulas
Range	Formula
N7:N30	N7	=IFERROR(LOOKUP(2, 1/((COUNTIF($N$7:N7,$H$3:$H$499)=0)*($H$3:$H$499<>"")),$H$3:$H$499),"")
O7:O30	O7	=COUNTIFS($A$3:$A$999,"W",$H$3:$H$999,N7)
P7:P30	P7	=COUNTIFS($A$3:$A$999,"L",$H$3:$H$999,N7)
Q7:Q30	Q7	=IFERROR(O7/(O7+P7),"")
S7:S30	S7	=INDEX($N$6:$N$35,AGGREGATE(15,6,(ROW($N$6:$N$35)-ROW($N$6)+1)/($Q$6:$Q$35=T7),COUNTIFS(T$7:T7,T7)))
T7:T30	T7	=LARGE($Q$6:$Q$35,ROWS(T$7:T7))
U7:U30	U7	=COUNTIF($Q$6:$Q$35,T7)

 

[Fluff]

In that case try

+Fluff 1.xlsm
	N	O	P	Q	R	S	T	U
6	Team	W	L	W %		Team	MAX	Count %
7	SAC	4	2	67%		GS	100%	2
8	BOS	1	1	50%		MIA	100%	2
9	MIL	0	1	0%		UTA	80%	1
10	CHA	2	2	50%		PHX	75%	2
11	ATL	3	6	33%		MIN	75%	2
12	UTA	4	1	80%		SAC	67%	2
13	GS	1	0	100%		MEM	67%	2
14	MEM	2	1	67%		BOS	50%	4
15	OKC	0	2	0%		CHA	50%	4
16	LAC	1	1	50%		LAC	50%	4
17	PHX	3	1	75%		TOR	50%	4
18	WAS	1	3	25%		ATL	33%	1
19	BRK	0	2	0%		WAS	25%	1
20	IND	0	2	0%		MIL	0%	9
21	CHI	0	2	0%		OKC	0%	9
22	DEN	0	1	0%		BRK	0%	9
23	LAL	0	1	0%		IND	0%	9
24	MIN	3	1	75%		CHI	0%	9
25	TOR	2	2	50%		DEN	0%	9
26	MIA	2	0	100%		LAL	0%	9
27	ORL	0	1	0%		ORL	0%	9
28	HOU	0	1	0%		HOU	0%	9
29		0	0			#NUM!	#NUM!	0
30		0	0
31
Main

Cell Formulas
Range	Formula
S7:S29	S7	=INDEX($N$7:$N$30,AGGREGATE(15,6,(ROW($N$7:$N$30)-ROW($N$7)+1)/($Q$7:$Q$30=T7),COUNTIFS(T$7:T7,T7)))
T7:T29	T7	=LARGE($Q$7:$Q$30,ROWS(T$7:T7))
U7:U29	U7	=COUNTIF($Q$7:$Q$30,T7)
Q7:Q30	Q7	=IFERROR(O7/(O7+P7),"")

 

[gtd526]

In that case try

+Fluff 1.xlsm
	N	O	P	Q	R	S	T	U
6	Team	W	L	W %		Team	MAX	Count %
7	SAC	4	2	67%		GS	100%	2
8	BOS	1	1	50%		MIA	100%	2
9	MIL	0	1	0%		UTA	80%	1
10	CHA	2	2	50%		PHX	75%	2
11	ATL	3	6	33%		MIN	75%	2
12	UTA	4	1	80%		SAC	67%	2
13	GS	1	0	100%		MEM	67%	2
14	MEM	2	1	67%		BOS	50%	4
15	OKC	0	2	0%		CHA	50%	4
16	LAC	1	1	50%		LAC	50%	4
17	PHX	3	1	75%		TOR	50%	4
18	WAS	1	3	25%		ATL	33%	1
19	BRK	0	2	0%		WAS	25%	1
20	IND	0	2	0%		MIL	0%	9
21	CHI	0	2	0%		OKC	0%	9
22	DEN	0	1	0%		BRK	0%	9
23	LAL	0	1	0%		IND	0%	9
24	MIN	3	1	75%		CHI	0%	9
25	TOR	2	2	50%		DEN	0%	9
26	MIA	2	0	100%		LAL	0%	9
27	ORL	0	1	0%		ORL	0%	9
28	HOU	0	1	0%		HOU	0%	9
29		0	0			#NUM!	#NUM!	0
30		0	0
31
Main

Cell Formulas
Range	Formula
S7:S29	S7	=INDEX($N$7:$N$30,AGGREGATE(15,6,(ROW($N$7:$N$30)-ROW($N$7)+1)/($Q$7:$Q$30=T7),COUNTIFS(T$7:T7,T7)))
T7:T29	T7	=LARGE($Q$7:$Q$30,ROWS(T$7:T7))
U7:U29	U7	=COUNTIF($Q$7:$Q$30,T7)
Q7:Q30	Q7	=IFERROR(O7/(O7+P7),"")

When I copy your results to a new workbook, it looks great, the same results. But when I apply the formula's you recommended, I get odd results. The N:N contains a formula to get the results of Teams I've bet (H:H).
Maybe the formula in N:N is messing things up? When I copy/paste sv on N:N, I get the correct results. I didn't do anything to O,P,Q.
Is there a way to add new teams to the list in N:N, assuming I copy/paste sv of the existing list? Meaning to add teams to N31,N32,N33, etc.
The list in N:N is created from column H:H, as indicated in N:N formula. Hopefully this makes "some" sense. Here is part of the worksheet do to size (if needed).

Wagers.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Status	Date	Balance	League		Risk	To Win	My Team	Opp	SPRD	$$$
2			$ 86.02
3	W	8/6		NBA	SPRD	$ 5.00	$ 4.55	MIL	MIA	-9	$ 4.55			Unique:	23		INDEX(F16:H18,MATCH(50,G16:G29,0),1)
4											$ 4.55			+1 for blank
5			$ 90.57	Balance																Best Betting Teams
6	L	8/7		NBA	SPRD	$ 5.00	$ 4.55	OKC	MEM	-4	$ (5.00)			Team	W	L	W %		Team	MAX	Count %
7											$ (5.00)			BRK	1	1	50%		ATL	100%	2
8			$ 85.57	Balance										UTA	4	2	67%		MIA	100%	2
9	L	8/8		NBA	SPRD	$ 5.00	$ 4.55	MIL	DAL	-5.5	$ (5.00)			BOS	2	2	50%		CHA	80%	1
10											$ (5.00)			SAC	0	1	0%		PHX	75%	2
11			$ 80.57	Balance										CHA	4	1	80%		UTA	75%	2
12	W	8/9		NBA	SPRD	$ 5.00	$ 4.55	TOR	MEM	-6.5	$ 4.55			MIL	3	6	33%		UTA	67%	2
13											$ 4.55			GS	2	1	67%		BRK	67%	3
14			$ 85.12	Balance										ATL	1	0	100%		BRK	50%	4
15	L	8/11		NBA	SPRD	$ 5.00	$ 4.55	DAL	POR	2	$ (5.00)			MEM	1	1	50%		BOS	50%	5
16											$ (5.00)			OKC	0	2	0%		MEM	50%	4
17			$ 80.12	Balance										LAC	1	3	25%		MIL	33%	1
18	L	8/12		NBA	SPRD	$ 5.00	$ 4.55	TOR	PHI	-6.5	$ (5.00)			PHX	3	1	75%		SAC	33%	1
19											$ (5.00)			WAS	0	2	0%		SAC	25%	1
20			$ 75.12	Balance										IND	0	2	0%		SAC	0%	10
21	L	8/20		NBA	SPRD	$ 5.00	$ 4.55	ORL	MIL	12.5	$ (5.00)			CHI	0	1	0%		OKC	0%	10
22											$ (5.00)			DEN	0	2	0%		WAS	0%	10
23			$ 70.12	Balance										LAL	3	1	75%		IND	0%	9
24	W	8/21		NBA	SPRD	$ 5.00	$ 4.55	BOS	PHI	-6.5	$ 4.55			MIN	0	1	0%		CHI	0%	10
25											$ 4.55			TOR	2	2	50%		DEN	0%	10
26			$ 74.67	Balance										MIA	2	0	100%		MIN	0%	10
27	L	8/22		NBA	SPRD	$ 5.00	$ 4.55	HOU	OKC	-2	$ (5.00)			ORL	0	1	0%		ORL	0%	10
28											$ (5.00)			HOU	0	1	0%		HOU	0%	10
29			$ 69.67	Balance											0	0			#NUM!	#NUM!	0
30	W	8/23		NBA	SPRD	$ 5.00	$ 4.55	TOR	BKR	-12	$ 4.55			DAL	0	1	0%		#NUM!	#NUM!	0
31											$ 4.55
32			$ 74.22	Balance
33	W	8/24		NBA	SPRD	$ 5.00	$ 4.55	MIA	IND	-6	$ 4.55
34											$ 4.55
35			$ 78.77	Balance
36	L	8/25		NBA	SPRD	$ 5.00	$ 4.55	UTA	DEN	-3	$ (5.00)
37											$ (5.00)
38			$ 73.77	Balance
NBA

Cell Formulas
Range	Formula
O3	O3	=SUMPRODUCT(1/COUNTIF(H3:H141,H3:H141&""))
K3,K36,K33,K30,K27,K24,K21,K18,K15,K12,K9,K6	K3	=SUMIF(A3,"W",G3)+SUMIF(A3,"L",F3)*-1
K4,K37,K34,K31,K28,K25,K22,K19,K16,K13,K10,K7	K4	=SUM(K3:K3)
C5,C38,C35,C32,C29,C26,C23,C20,C17,C14,C11,C8	C5	=C2+K4
N7:N30	N7	=IFERROR(LOOKUP(2, 1/((COUNTIF($N$7:N7,$H$3:$H$499)=0)*($H$3:$H$499<>"")),$H$3:$H$499),"")
O7:O30	O7	=COUNTIFS($A$3:$A$999,"W",$H$3:$H$999,N7)
P7:P30	P7	=COUNTIFS($A$3:$A$999,"L",$H$3:$H$999,N7)
Q36,Q7:Q30	Q7	=IFERROR(O7/(O7+P7),"")
S7:S30	S7	=INDEX($N$7:$N$30,AGGREGATE(15,6,(ROW($N$7:$N$30)-ROW($N$7)+1)/($Q$7:$Q$30=T7),COUNTIFS(T$7:T7,T7)))
T7:T30	T7	=LARGE($Q$7:$Q$30,ROWS(T$7:T7))
U7:U30	U7	=COUNTIF($Q$7:$Q$30,T7)

 

[Fluff]

You have circular references, which is why you are getting problems, change the formula in N7 to

=IFERROR(LOOKUP(2, 1/((COUNTIF($N$6:N6,$H$3:$H$499)=0)*($H$3:$H$499<>"")),$H$3:$H$499),"")