Check if a previously drawn number is in a group.

[Samgraphics]

Please help me,
Currently I'm using this formula to check if a previously drawn number is in the group,the countifs, but it's long and it's really slowing down excel. Is there another way to do it? A less cumbersome way?

All combinations 2023-24.xlsm
	C	D	E	F	G	H	I	J	K	L	M	N
1	1	2	3	4	5			1	2	3	4	30
2	1	2	3	4	6			9	20	23	29	33
3	1	2	3	4	7			4	13	15	17	32
4	1	2	3	4	8			4	22	25	30	31
5	1	2	3	4	9			1	2	9	19	30
6	1	2	3	4	10			15	16	25	31	34
7	1	2	3	4	11			7	12	20	28	31
8	1	2	3	4	12			4	19	21	30	31
9	1	2	3	4	13			13	23	27	30	34
10	1	2	3	4	14			5	18	22	28	29
11	1	2	3	4	15			10	15	22	27	33
12	1	2	3	4	16			10	18	25	28	33
13	1	2	3	4	17			3	4	12	15	23
14	1	2	3	4	18			3	7	21	22	24
15	1	2	3	4	19			13	20	27	29	30
16	1	2	3	4	20			9	23	25	27	33
17	1	2	3	4	21			1	5	7	12	13
18	1	2	3	4	22			4	7	8	18	19
19	1	2	3	4	23			7	12	17	26	34
20	1	2	3	4	24			7	25	26	29	32
21	1	2	3	4	25			6	18	23	27	32
22	1	2	3	4	26			2	14	16	28	30
23	1	2	3	4	27			1	7	9	25	29
24	1	2	3	4	28			5	11	15	23	33
25	1	2	3	4	29			2	8	16	31	34
26	1	2	3	4	30			4	8	10	14	21
DA LUO TO

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:G98280	Expression	=COUNTIFS($J$1:$J$98280,$C1,$K$1:$K$98280,$D1,$L$1:$L$98280,$E1,$M$1:$M$98280,$F1,$N$1:$N$98280,$G1)	text	NO
C1:G98280	Expression	=MIN($D1:$G1-$C1:$F1)=MAX($D1:$G1-$C1:$F1)	text	NO
C1:G98280	Expression	=MIN(($E1:$G1-$D1:$F1)-($D1:$F1-$C1:$E1))=MAX(($E1:$G1-$D1:$F1)-($D1:$F1-$C1:$E1))	text	NO

Thank you so much.

 

[Excel Novice 1]

I am interpreting the "drawn number" as the combination of the 5 numbers in columns I-M similar to lottery results and the search combination to be the aggregate of Columns A-E. If you are ok with using multiple columns, the following might work:
- Convert the series of 5 numbers into a combined text string. This will give you the unique combination for each row.
- Do the same thing for data in I-M
- Do a match or countif of the unique identifier in G with the unique identifier in O

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1							Unique identifier for A-E								Unique identifier for A-O	Is G In I-M dataset?
2	1	2	3	4	5		12345		1	2	3	4	30		123430	#N/A
3	1	2	3	4	6		12346		9	20	23	29	33		920232933	#N/A
4	1	2	3	4	7		12347		4	13	15	17	32		413151732	#N/A
5	1	2	3	4	8		12348		4	22	25	30	31		422253031	#N/A
6	1	2	3	4	9		12349		1	2	9	19	30		1291930	#N/A
7	1	2	3	4	10		123410		15	16	25	31	34		1516253134	#N/A
8	1	2	3	4	11		123411		7	12	20	28	31		712202831	#N/A
9	1	2	3	4	12		123412		4	19	21	30	31		419213031	#N/A
10	1	2	3	4	13		123413		13	23	27	30	34		1323273034	#N/A
11	1	2	3	4	14		123414		5	18	22	28	29		518222829	#N/A
12	1	2	3	4	15		123415		10	15	22	27	33		1015222733	#N/A
13	1	2	3	4	16		123416		10	18	25	28	33		1018252833	#N/A
14	1	2	3	4	17		123417		3	4	12	15	23		34121523	#N/A
15	1	2	3	4	18		123418		3	7	21	22	24		37212224	#N/A
16	1	2	3	4	19		123419		13	20	27	29	30		1320272930	#N/A
17	1	2	3	4	20		123420		9	23	25	27	33		923252733	#N/A
18	1	2	3	4	21		123421		1	5	7	12	13		1571213	#N/A
19	1	2	3	4	22		123422		4	7	8	18	19		4781819	#N/A
20	1	2	3	4	23		123423		7	12	17	26	34		712172634	#N/A
21	1	2	3	4	24		123424		7	25	26	29	32		725262932	#N/A
22	1	2	3	4	25		123425		6	18	23	27	32		618232732	#N/A
23	1	2	3	4	26		123426		2	14	16	28	30		214162830	#N/A
24	1	2	3	4	27		123427		1	7	9	25	29		1792529	#N/A
25	1	2	3	4	28		123428		5	11	15	23	33		511152333	#N/A
26	1	2	3	4	29		123429		2	8	16	31	34		28163134	#N/A
27	1	2	3	4	30		123430		4	8	10	14	21		48101421	1
Sheet1

Cell Formulas
Range	Formula
G2:G27,O2:O27	O2	=I2&J2&K2&L2&M2
P2:P27	P2	=MATCH(G2,$O$2:$O$27,0)

Named Ranges
Name	Refers To	Cells
_FilterDatabase	=Sheet1!$A$2:$O$52	G2