Check betting sets

[motilulla]

Hello,


I have a question I want to check my betting sets with all the results one by one and if matches greater than 10, 11, 12, 13, 14 filter those rows and copy paste them in another sheet one below another.


Data sheet is holding Results in the Columns C:P, Betting sets in the Columns R:AE, I am using formula in cell AF6 = SUMPRODUCT(--($C$6:$P$6=R6:AE6)) copied down to AF55 once match result are calculated I just filter AF row grater than 9 and copy data in sheet "Match Result"
Check for the next row match results I change the formula AF6 = SUMPRODUCT(--($C$7:$P$7=R6:AE6)) copied down to AF55 and repeat the process filter AF row grater than 9 and copy data in sheet "Match Result"

Is there any way it could be auto mechanize to check all result with betting sets and filter the matches and put them in the sheet "Match Result"

Sheet Data

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1
2
3
4	N	Year	n1	n2	n3	n4	n5	n6	n7	n8	n9	n10	n11	n12	n13	n14	EM1	n1	n2	n3	n4	n5	n6	n7	n8	n9	n10	n11	n12	n13	n14	Match
5	N	Year	n1	n2	n3	n4	n5	n6	n7	n8	n9	n10	n11	n12	n13	n14	EM1	n1	n2	n3	n4	n5	n6	n7	n8	n9	n10	n11	n12	n13	n14	Match
6	1	2001	1	1	1	1	1	1	1	1	1	2	2	1	1	1		1	1	1	1	1	1	1	1	1	1	1	1	1	1	12
7	2	2001	X	1	1	1	2	1	2	1	2	X	1	1	X	1		X	2	X	X	1	1	1	X	2	1	1	2	1	2	4
8	3	2001	X	X	2	1	X	X	1	1	2	1	X	2	1	1		X	2	X	2	2	X	1	1	2	1	X	2	X	2	2
9	4	2001	2	1	1	X	2	1	X	1	1	2	2	1	1	1		1	1	1	2	2	1	2	1	1	2	2	1	X	1	10
10	5	2001	1	X	1	X	1	1	2	1	1	X	X	X	1	1		2	X	1	X	2	1	1	1	2	2	2	1	1	X	8
11	6	2001	X	2	X	X	2	X	1	1	2	1	1	1	1	2		X	1	X	X	2	1	X	1	1	2	2	2	2	1	7
12	7	2001	X	1	1	2	1	1	1	2	1	1	X	1	X	1		1	X	1	1	2	1	1	1	2	1	X	X	2	1	7
13																		X	1	1	2	1	2	1	2	X	2	X	1	1	1	8
14																		1	1	2	1	1	1	X	1	1	2	2	X	1	X	10
15																		1	2	1	X	1	X	2	X	1	X	X	X	2	1	5
16																		2	2	1	2	1	1	1	X	2	1	1	X	1	1	6
17																		1	2	X	X	2	X	2	1	2	X	1	1	1	X	4
18																		1	1	1	1	1	2	X	2	2	2	1	1	1	1	9
19																		X	1	1	2	2	1	X	2	2	X	1	1	X	X	4
20																		2	2	1	2	1	1	1	2	1	1	1	1	2	1	7
21																		X	X	1	X	1	1	2	1	1	1	2	X	1	2	7
22																		1	1	2	1	1	1	X	1	1	2	2	X	1	X	10
23																		1	2	X	1	2	1	1	X	1	1	X	1	1	1	8
24																		2	1	2	X	2	X	X	2	1	2	2	1	1	X	6
25																		X	2	X	1	2	1	2	1	X	X	1	1	X	2	4
26																		X	X	X	1	X	1	X	1	1	1	1	1	1	1	7
27																		1	1	1	1	X	X	1	1	1	2	1	2	X	1	9
28																		1	X	X	1	X	1	1	1	1	2	1	2	X	1	8
29																		X	X	2	X	1	1	1	1	1	1	X	2	1	1	7
30																		X	1	1	1	X	X	X	1	1	1	1	1	X	2	6
31																		X	X	1	2	X	X	1	1	X	1	X	2	1	2	4
32																		1	2	X	1	1	X	X	1	2	1	1	1	X	1	6
33																		1	1	1	2	1	1	X	1	1	1	X	2	X	1	8
34																		1	1	2	X	X	1	1	2	1	1	1	1	X	1	7
35																		X	X	1	1	1	1	2	1	2	X	2	1	X	X	7
36																		1	1	1	2	1	1	X	1	1	1	X	2	X	1	8
37																		X	X	2	X	1	1	1	1	1	1	X	2	1	1	7
38																		1	X	1	X	2	1	1	X	1	X	2	X	1	1	8
39																		2	1	X	1	X	1	1	1	X	2	X	1	1	1	9
40																		X	2	2	1	2	1	2	1	2	2	1	1	2	1	6
41																		1	1	1	2	2	1	1	1	1	1	1	X	1	2	8
42																		2	1	X	1	2	1	X	2	1	2	2	X	1	1	8
43																		1	1	1	X	1	X	1	1	1	1	2	1	2	X	9
44																		X	1	1	1	2	1	2	1	X	X	X	X	X	2	5
45																		2	X	1	2	1	X	2	1	1	1	1	X	1	1	6
46																		1	2	1	1	X	2	2	1	X	1	1	1	1	2	6
47																		1	1	1	1	X	X	1	2	1	1	2	1	2	X	8
48																		X	X	1	1	1	X	1	2	1	2	1	X	1	1	8
49																		X	1	1	1	X	X	2	1	1	X	X	1	1	1	8
50																		1	1	X	X	1	X	2	1	1	1	X	X	1	1	7
51																		1	1	1	1	2	2	2	X	X	X	1	1	X	1	6
52																		1	2	1	1	1	2	X	2	1	1	2	1	2	1	8
53																		1	1	1	2	2	1	2	1	1	2	2	1	X	1	10
54																		X	X	1	2	X	1	1	1	1	X	1	1	2	1	7
55																		1	1	2	X	1	2	1	X	1	1	1	X	1	1	7
Data

Sheet Match Result

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1
2
3
4	N	Year	n1	n2	n3	n4	n5	n6	n7	n8	n9	n10	n11	n12	n13	n14	EM1	n1	n2	n3	n4	n5	n6	n7	n8	n9	n10	n11	n12	n13	n14	Match
5	N	Year	n1	n2	n3	n4	n5	n6	n7	n8	n9	n10	n11	n12	n13	n14	EM1	n1	n2	n3	n4	n5	n6	n7	n8	n9	n10	n11	n12	n13	n14	Match
6	1	2001	1	1	1	1	1	1	1	1	1	2	2	1	1	1		1	1	1	1	1	1	1	1	1	1	1	1	1	1	12
7																		1	1	1	2	2	1	2	1	1	2	2	1	X	1	10
8																		1	1	2	1	1	1	X	1	1	2	2	X	1	X	10
9																		1	1	2	1	1	1	X	1	1	2	2	X	1	X	10
10																		1	1	1	2	2	1	2	1	1	2	2	1	X	1	10
11
12	2	2001	X	1	1	1	2	1	2	1	2	X	1	1	X	1		X	1	1	2	2	1	X	2	2	X	1	1	X	X	10
13																		X	2	X	1	2	1	2	1	X	X	1	1	X	2	10
14																		X	X	1	1	1	1	2	1	2	X	2	1	X	X	10
15																		X	2	2	1	2	1	2	1	2	2	1	1	2	1	10
16																		X	1	1	1	2	1	2	1	X	X	X	X	X	2	10
17																		1	1	1	1	2	2	2	X	X	X	1	1	X	1	10
18
19	3	2001	X	X	2	1	X	X	1	1	2	1	X	2	1	1		X	X	2	X	1	1	1	1	1	1	X	2	1	1	10
20																		X	X	1	2	X	X	1	1	X	1	X	2	1	2	10
21																		X	X	2	X	1	1	1	1	1	1	X	2	1	1	10
22
23	4	2001	2	1	1	X	2	1	X	1	1	2	2	1	1	1		X	X	2	X	1	1	1	1	1	1	X	2	1	1	10
24																		X	X	1	2	X	X	1	1	X	1	X	2	1	2	10
25																		X	X	2	X	1	1	1	1	1	1	X	2	1	1	10
26
27	5	2001	1	X	1	X	1	1	2	1	1	X	X	X	1	1		X	X	2	X	1	1	1	1	1	1	X	2	1	1	10
28																		X	X	1	2	X	X	1	1	X	1	X	2	1	2	10
29																		X	X	2	X	1	1	1	1	1	1	X	2	1	1	10
30
31	6	2001	X	2	X	X	2	X	1	1	2	1	1	1	1	2		X	X	2	X	1	1	1	1	1	1	X	2	1	1	10
32																		X	X	1	2	X	X	1	1	X	1	X	2	1	2	10
33																		X	X	2	X	1	1	1	1	1	1	X	2	1	1	10
34
35	7	2001	X	1	1	2	1	1	1	2	1	1	X	1	X	1		X	X	2	X	1	1	1	1	1	1	X	2	1	1	10
36																		X	X	1	2	X	X	1	1	X	1	X	2	1	2	10
37																		X	X	2	X	1	1	1	1	1	1	X	2	1	1	10
Match Result

Thank you all
Excel 2000
Regards,
Moti

 

[Rick Rothstein]

Re: Check betting sets not sure is it possible.

Hello,

Rick Rothstein, My English is not bad but is not good too. I am saying recent code posed in the post#15 is running flawless every time.

Great... thanks for the confirmation.