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)

 

[gtd526]

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)

Here are the results after paste sv...

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

Cell Formulas
Range	Formula
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$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)

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),"")

Perfection! Thanks for the formula.
What is the Circular reference in the previous formula?
Here are the results:

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

Cell Formulas
Range	Formula
O7:O30	O7	=COUNTIFS($A$3:$A$998,"W",$H$3:$H$998,N7)
P7:P30	P7	=COUNTIFS($A$3:$A$998,"L",$H$3:$H$998,N7)
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)
N7:N33	N7	=IFERROR(LOOKUP(2, 1/((COUNTIF($N$6:N6,$H$3:$H$499)=0)*($H$3:$H$499<>"")),$H$3:$H$499),"")

 

[Fluff]

You had

COUNTIF($N$7:N7,$H$3:$H$499)=0)

so N7 was counting itself, which is a circular reference.

 

[gtd526]

You had

COUNTIF($N$7:N7,$H$3:$H$499)=0)

so N7 was counting itself, which is a circular reference.

Thank you.

 

[Fluff]

You're welcome