How to find doubles, triplets, and quadruplets in a range of listed numbers

[caneki]

I saw a thread posted recently and
I actually used Snakehips' answer and it was very good.
I have additional questions
How do I find quadruples?

 

[arun_eagertolearn]

In column Y, please do UNIQUE(H2:Q14) for listing down all the possible entries

Right beside these entries in column Y, in column Z, please put countif(H2:Q14)

Then, in column AB- please put sortby(Y:Z, Z:Z)- this would sort the columns by the count which is there in Z:Z

 

[caneki]

In column Y, please do UNIQUE(H2:Q14) for listing down all the possible entries

Right beside these entries in column Y, in column Z, please put countif(H2:Q14)

Then, in column AB- please put sortby(Y:Z, Z:Z)- this would sort the columns by the count which is there in Z:Z

Thanks for the answer.
This is a triplets function formula.

=TRANSPOSE(LET(tr,TOCOL(B25#&"-"&TRANSPOSE(U2:Y2)),FILTER(tr,1*TEXTAFTER(TEXTBEFORE(tr,"-",2),"-")<1*TEXTAFTER(tr,"-",2))))

I would like to know how to modify this function to quadruplets, how should I modify it?

 

[arun_eagertolearn]

Hi

Please check this

For triplets
=TRANSPOSE(LET(outarr,LET(arr,WRAPROWS(TEXTSPLIT(TEXTJOIN("-",,TOROW((B2:F2)&"-"&TRANSPOSE(H2#))),"-")*1,3),FILTER(arr,CHOOSECOLS(arr,1)<CHOOSECOLS(arr,2))),CHOOSECOLS(outarr,1)&"-"&CHOOSECOLS(outarr,2)&"-"&CHOOSECOLS(outarr,3)))
For quadraplets
=TRANSPOSE(LET(outarr,LET(arr,WRAPROWS(TEXTSPLIT(TEXTJOIN("-",,TOROW((B2:F2)&"-"&TRANSPOSE(H15#))),"-")*1,4),FILTER(arr,CHOOSECOLS(arr,1)<CHOOSECOLS(arr,2))),CHOOSECOLS(outarr,1)&"-"&CHOOSECOLS(outarr,2)&"-"&CHOOSECOLS(outarr,3)&"-"&CHOOSECOLS(outarr,4)))

Differences between the triplets and quadraplets
Source- H2# array- takes from pairs, to build triplets, H15# array takes from triplets to build quadraplets

The 3 (for triplets) and 4( for quadraplets) highlighted above in Red
The last "-"&CHOOSECOLS(outarr,4) which is additional for quadraplets

The fundamental logic is as suggested by @snake Hips

Triplets, Qudraplets etc.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Input						All possible pairs											Count>=2
2	5	15	18	25	28		5-15	5-18	15-18	5-25	15-25	18-25	5-28	15-28	18-28	25-28		5-25	2
3	2	37	16	35	45		2-37	16-37	35-37	2-16	2-35	16-35	2-45	37-45	16-45	35-45		5-28	2
4	5	25	28	36	38		5-25	5-28	25-28	5-36	25-36	28-36	5-38	25-38	28-38	36-38		25-28	2
5	8	16	35	37	45		8-16	8-35	16-35	8-37	16-37	35-37	8-45	16-45	35-45	37-45		16-37	2
6	4	10	19	20	43		4-10	4-19	10-19	4-20	10-20	19-20	4-43	10-43	19-43	20-43		35-37	2
7																		16-35	2
8																		37-45	2
9																		16-45	2
10																		35-45	2
11
12
13
14							All possible triplets											Count>=2
15							5-15-18	5-15-25	5-18-25	15-18-25	5-15-28	5-18-28	15-18-28	5-25-28	15-25-28	18-25-28		5-25-28	2
16							2-16-37	2-35-37	16-35-37	2-16-35	2-37-45	16-37-45	35-37-45	2-16-45	2-35-45	16-35-45		16-35-37	2
17							5-25-28	5-25-36	5-28-36	25-28-36	5-25-38	5-28-38	25-28-38	5-36-38	25-36-38	28-36-38		16-37-45	2
18							8-16-35	8-16-37	8-35-37	16-35-37	8-16-45	8-35-45	16-35-45	8-37-45	16-37-45	35-37-45		35-37-45	2
19							4-10-19	4-10-20	4-19-20	10-19-20	4-10-43	4-19-43	10-19-43	4-20-43	10-20-43	19-20-43		16-35-45	2
20
21																		Count>=2
22							5-15-18-25	5-15-18-28	5-15-25-28	5-18-25-28	15-18-25-28							16-35-37-45	2
23							2-16-35-37	2-16-37-45	2-35-37-45	16-35-37-45	2-16-35-45
24							5-25-28-36	5-25-28-38	5-25-36-38	5-28-36-38	25-28-36-38
25							8-16-35-37	8-16-35-45	8-16-37-45	8-35-37-45	16-35-37-45
26							4-10-19-20	4-10-19-43	4-10-20-43	4-19-20-43	10-19-20-43
Sheet3

Cell Formulas
Range	Formula
S2:S10,S22,S15:S19	S2	=UNIQUE(TOCOL(IF(COUNTIF(H2:Q6,H2:Q6)>1,H2:Q6,1/0),3))
T2:T10,T22,T15:T19	T2	=COUNTIF(H2:Q6,S2#)
H2:Q6	H2	=LET(arr,TOROW((B2:F2)&"-"&TRANSPOSE(B2:F2)),FILTER(arr,TEXTBEFORE(arr,"-")*1<TEXTAFTER(arr,"-")*1))
H15:Q19	H15	=TRANSPOSE(LET(outarr,LET(arr,WRAPROWS(TEXTSPLIT(TEXTJOIN("-",,TOROW((B2:F2)&"-"&TRANSPOSE(H2#))),"-")*1,3),FILTER(arr,CHOOSECOLS(arr,1)<CHOOSECOLS(arr,2))),CHOOSECOLS(outarr,1)&"-"&CHOOSECOLS(outarr,2)&"-"&CHOOSECOLS(outarr,3)))
H22:L26	H22	=TRANSPOSE(LET(outarr,LET(arr,WRAPROWS(TEXTSPLIT(TEXTJOIN("-",,TOROW((B2:F2)&"-"&TRANSPOSE(H15#))),"-")*1,4),FILTER(arr,CHOOSECOLS(arr,1)<CHOOSECOLS(arr,2))),CHOOSECOLS(outarr,1)&"-"&CHOOSECOLS(outarr,2)&"-"&CHOOSECOLS(outarr,3)&"-"&CHOOSECOLS(outarr,4)))
Dynamic array formulas.

 

[Snakehips]

@caneki
Here is an extension of the solution I provided previously that hopefully sorts Quadruplets?

AutoTraining.xlsm
	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
1		Range of Numbers						Pairs	Times		Triplets	Times		Quads	Times						Range Check
2		3	15	18	25	28		25-28	2		16-35-45	2		None	0						10	16	19	43	20
3		2	5	16	35	45		16-35	2												As a result of adding above range:
4		5	25	28	36	38		16-45	2												Pairs	Times		Triplets	Times		Quads	Times
5		8	16	35	37	45		35-45	2												25-28	2		16-35-45	2		10-19-20-43	2
6		4	10	19	20	43															16-35	2		10-19-20	2
7																					16-45	2		10-19-43	2
8																					35-45	2		10-20-43	2
9																					10-19	2		19-20-43	2
10																					10-20	2
11																					19-20	2
12																					10-43	2
13																					19-43	2
14																					20-43	2
15
16
17
18
19
20	Pairs Helper	3-15	3-18	15-18	3-25	15-25	18-25	3-28	15-28	18-28	25-28
21	Numbers Pairs	2-5	2-16	5-16	2-35	5-35	16-35	2-45	5-45	16-45	35-45
22		5-25	5-28	25-28	5-36	25-36	28-36	5-38	25-38	28-38	36-38
23		8-16	8-35	16-35	8-37	16-37	35-37	8-45	16-45	35-45	37-45
24		4-10	4-19	10-19	4-20	10-20	19-20	4-43	10-43	19-43	20-43
25	Check Pairs	10-16	10-19	16-19	10-43	16-43	19-43	20-43	10-20	16-20	19-20
26
27
28	Triplets Helper	3-15-18	3-15-25	3-18-25	15-18-25	3-15-28	3-18-28	15-18-28	3-25-28	15-25-28	18-25-28
29	Numbers Triplets	2-5-16	2-5-35	2-16-35	5-16-35	2-5-45	2-16-45	5-16-45	2-35-45	5-35-45	16-35-45
30		5-25-28	5-25-36	5-28-36	25-28-36	5-25-38	5-28-38	25-28-38	5-36-38	25-36-38	28-36-38
31		8-16-35	8-16-37	8-35-37	16-35-37	8-16-45	8-35-45	16-35-45	8-37-45	16-37-45	35-37-45
32		4-10-19	4-10-20	4-19-20	10-19-20	4-10-43	4-19-43	10-19-43	4-20-43	10-20-43	19-20-43
33	Check Triples	10-16-19	10-16-43	10-19-43	16-19-43	10-20-43	16-20-43	19-20-43	10-16-20	10-19-20	16-19-20
34
35
36	Quads Helper	3-15-18-25	3-15-18-28	3-15-25-28	3-18-25-28	15-18-25-28
37	Numbers Triplets	2-5-16-35	2-5-16-45	2-5-35-45	2-16-35-45	5-16-35-45
38		5-25-28-36	5-25-28-38	5-25-36-38	5-28-36-38	25-28-36-38
39		8-16-35-37	8-16-35-45	8-16-37-45	8-35-37-45	16-35-37-45
40		4-10-19-20	4-10-19-43	4-10-20-43	4-19-20-43	10-19-20-43
41	Check Quads	10-16-19-20	10-16-19-43	10-16-20-43	10-19-20-43	16-19-20-43
Sheet11

Cell Formulas
Range	Formula
H2:H5	H2	=IFERROR(UNIQUE(TOCOL(IF(COUNTIF(B20:K24,B20:K24)>1,B20:K24,1/0),3)),"None")
I2:I5	I2	=COUNTIF(B20:K24,H2#)
K2	K2	=IFERROR(UNIQUE(TOCOL(IF(COUNTIF(B28:K32,B28:K32)>1,B28:K32,1/0),3)),"None")
L2	L2	=COUNTIF(B28:K32,K2#)
N2	N2	=IFERROR(UNIQUE(TOCOL(IF(COUNTIF(B36:F40,B36:F40)>1,B36:F40,1/0),3)),"None")
O2	O2	=COUNTIF(B36:F40,N2#)
U5:U14	U5	=IFERROR(UNIQUE(TOCOL(IF(COUNTIF(B20:K25,B20:K25)>1,B20:K25,1/0),3)),"None")
V5:V14	V5	=COUNTIF(B20:K25,U5#)
X5:X9	X5	=IFERROR(UNIQUE(TOCOL(IF(COUNTIF(B28:K33,B28:K33)>1,B28:K33,1/0),3)),"None")
Y5:Y9	Y5	=COUNTIF(B28:K33,X5#)
AA5	AA5	=IFERROR(UNIQUE(TOCOL(IF(COUNTIF(B36:F41,B36:F41)>1,B36:F41,1/0),3)),"None")
AB5	AB5	=COUNTIF(B36:F41,AA5#)
B20:K24	B20	=TRANSPOSE(LET(rw,TOCOL(B2:F2&"-"&TRANSPOSE(B2:F2)),FILTER(rw,1*TEXTBEFORE(rw,"-")<1*TEXTAFTER(rw,"-"))))
B25:K25	B25	=TRANSPOSE(LET(rw,TOCOL(U2:Y2&"-"&TRANSPOSE(U2:Y2)),FILTER(rw,1*TEXTBEFORE(rw,"-")<1*TEXTAFTER(rw,"-"))))
B28:K32	B28	=TRANSPOSE(LET(tr,TOCOL(B20#&"-"&TRANSPOSE(B2:F2)),FILTER(tr,1*TEXTAFTER(TEXTBEFORE(tr,"-",2),"-")<1*TEXTAFTER(tr,"-",2))))
B33:K33	B33	=TRANSPOSE(LET(tr,TOCOL(B25#&"-"&TRANSPOSE(U2:Y2)),FILTER(tr,1*TEXTAFTER(TEXTBEFORE(tr,"-",2),"-")<1*TEXTAFTER(tr,"-",2))))
B36:B40	B36	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2,3,4}))
C36:C40	C36	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2,3,5}))
D36:D40	D36	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2,4,5}))
E36:E40	E36	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,3,4,5}))
F36:F40	F36	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,3,4,5}))
B41	B41	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2,3,4}))
C41	C41	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2,3,5}))
D41	D41	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2,4,5}))
E41	E41	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,3,4,5}))
F41	F41	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,3,4,5}))
Dynamic array formulas.

 

[Snakehips]

Alternative formula for the Pairs and Triplet helpers, similar to used for Quads.

AutoTraining.xlsm
	A	B	C	D	E	F	G	H	I	J	K
20	Pairs Helper	3-15	3-18	3-25	3-28	15-18	15-25	15-28	18-25	18-28	25-28
21	Numbers Pairs	2-5	2-16	2-35	2-45	5-16	5-35	5-45	16-35	16-45	35-45
22		5-25	5-28	5-36	5-38	25-28	25-36	25-38	28-36	28-38	36-38
23		8-16	8-35	8-37	8-45	16-35	16-37	16-45	35-37	35-45	37-45
24		4-10	4-19	4-20	4-43	10-19	10-20	10-43	19-20	19-43	20-43
25	Check Pairs	10-16	10-19	10-20	10-43	16-19	16-20	16-43	19-20	19-43	20-43
26
27
28	Triplets Helper	3-15-18	3-15-25	3-15-28	3-18-25	3-18-28	3-25-28	15-18-25	15-18-28	15-25-28	18-25-28
29	Numbers Triplets	2-5-16	2-5-35	2-5-45	2-16-35	2-16-45	2-35-45	5-16-35	5-16-45	5-35-45	16-35-45
30		5-25-28	5-25-36	5-25-38	5-28-36	5-28-38	5-36-38	25-28-36	25-28-38	25-36-38	28-36-38
31		8-16-35	8-16-37	8-16-45	8-35-37	8-35-45	8-37-45	16-35-37	16-35-45	16-37-45	35-37-45
32		4-10-19	4-10-20	4-10-43	4-19-20	4-19-43	4-20-43	10-19-20	10-19-43	10-20-43	19-20-43
33	Check Triples	10-16-19	10-16-20	10-16-43	10-19-20	10-19-43	10-20-43	16-19-20	16-19-43	16-20-43	19-20-43
Sheet11 (2)

Cell Formulas
Range	Formula
B20:B24	B20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2}))
C20:C24	C20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,3}))
D20:D24	D20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,4}))
E20:E24	E20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,5}))
F20:F24	F20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,3}))
G20:G24	G20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,4}))
H20:H24	H20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,5}))
I20:I24	I20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{3,4}))
J20:J24	J20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{3,5}))
K20:K24	K20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{4,5}))
B25	B25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2}))
C25	C25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,3}))
D25	D25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,4}))
E25	E25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,5}))
F25	F25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,3}))
G25	G25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,4}))
H25	H25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,5}))
I25	I25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{3,4}))
J25	J25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{3,5}))
K25	K25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{4,5}))
B28:B32	B28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2,3}))
C28:C32	C28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2,4}))
D28:D32	D28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2,5}))
E28:E32	E28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,3,4}))
F28:F32	F28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,3,5}))
G28:G32	G28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,4,5}))
H28:H32	H28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,3,4}))
I28:I32	I28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,3,5}))
J28:J32	J28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,4,5}))
K28:K32	K28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{3,4,5}))
B33	B33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2,3}))
C33	C33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2,4}))
D33	D33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2,5}))
E33	E33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,3,4}))
F33	F33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,3,5}))
G33	G33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,4,5}))
H33	H33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,3,4}))
I33	I33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,3,5}))
J33	J33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,4,5}))
K33	K33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{3,4,5}))

 

[caneki]

Hi

Please check this

For triplets
=TRANSPOSE(LET(outarr,LET(arr,WRAPROWS(TEXTSPLIT(TEXTJOIN("-",,TOROW((B2:F2)&"-"&TRANSPOSE(H2#))),"-")*1,3),FILTER(arr,CHOOSECOLS(arr,1)<CHOOSECOLS(arr,2))),CHOOSECOLS(outarr,1)&"-"&CHOOSECOLS(outarr,2)&"-"&CHOOSECOLS(outarr,3)))
For quadraplets
=TRANSPOSE(LET(outarr,LET(arr,WRAPROWS(TEXTSPLIT(TEXTJOIN("-",,TOROW((B2:F2)&"-"&TRANSPOSE(H15#))),"-")*1,4),FILTER(arr,CHOOSECOLS(arr,1)<CHOOSECOLS(arr,2))),CHOOSECOLS(outarr,1)&"-"&CHOOSECOLS(outarr,2)&"-"&CHOOSECOLS(outarr,3)&"-"&CHOOSECOLS(outarr,4)))

Differences between the triplets and quadraplets
Source- H2# array- takes from pairs, to build triplets, H15# array takes from triplets to build quadraplets

The 3 (for triplets) and 4( for quadraplets) highlighted above in Red
The last "-"&CHOOSECOLS(outarr,4) which is additional for quadraplets

The fundamental logic is as suggested by @snake Hips

Triplets, Qudraplets etc.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Input						All possible pairs											Count>=2
2	5	15	18	25	28		5-15	5-18	15-18	5-25	15-25	18-25	5-28	15-28	18-28	25-28		5-25	2
3	2	37	16	35	45		2-37	16-37	35-37	2-16	2-35	16-35	2-45	37-45	16-45	35-45		5-28	2
4	5	25	28	36	38		5-25	5-28	25-28	5-36	25-36	28-36	5-38	25-38	28-38	36-38		25-28	2
5	8	16	35	37	45		8-16	8-35	16-35	8-37	16-37	35-37	8-45	16-45	35-45	37-45		16-37	2
6	4	10	19	20	43		4-10	4-19	10-19	4-20	10-20	19-20	4-43	10-43	19-43	20-43		35-37	2
7																		16-35	2
8																		37-45	2
9																		16-45	2
10																		35-45	2
11
12
13
14							All possible triplets											Count>=2
15							5-15-18	5-15-25	5-18-25	15-18-25	5-15-28	5-18-28	15-18-28	5-25-28	15-25-28	18-25-28		5-25-28	2
16							2-16-37	2-35-37	16-35-37	2-16-35	2-37-45	16-37-45	35-37-45	2-16-45	2-35-45	16-35-45		16-35-37	2
17							5-25-28	5-25-36	5-28-36	25-28-36	5-25-38	5-28-38	25-28-38	5-36-38	25-36-38	28-36-38		16-37-45	2
18							8-16-35	8-16-37	8-35-37	16-35-37	8-16-45	8-35-45	16-35-45	8-37-45	16-37-45	35-37-45		35-37-45	2
19							4-10-19	4-10-20	4-19-20	10-19-20	4-10-43	4-19-43	10-19-43	4-20-43	10-20-43	19-20-43		16-35-45	2
20
21																		Count>=2
22							5-15-18-25	5-15-18-28	5-15-25-28	5-18-25-28	15-18-25-28							16-35-37-45	2
23							2-16-35-37	2-16-37-45	2-35-37-45	16-35-37-45	2-16-35-45
24							5-25-28-36	5-25-28-38	5-25-36-38	5-28-36-38	25-28-36-38
25							8-16-35-37	8-16-35-45	8-16-37-45	8-35-37-45	16-35-37-45
26							4-10-19-20	4-10-19-43	4-10-20-43	4-19-20-43	10-19-20-43
Sheet3

Cell Formulas
Range	Formula
S2:S10,S22,S15:S19	S2	=UNIQUE(TOCOL(IF(COUNTIF(H2:Q6,H2:Q6)>1,H2:Q6,1/0),3))
T2:T10,T22,T15:T19	T2	=COUNTIF(H2:Q6,S2#)
H2:Q6	H2	=LET(arr,TOROW((B2:F2)&"-"&TRANSPOSE(B2:F2)),FILTER(arr,TEXTBEFORE(arr,"-")*1<TEXTAFTER(arr,"-")*1))
H15:Q19	H15	=TRANSPOSE(LET(outarr,LET(arr,WRAPROWS(TEXTSPLIT(TEXTJOIN("-",,TOROW((B2:F2)&"-"&TRANSPOSE(H2#))),"-")*1,3),FILTER(arr,CHOOSECOLS(arr,1)<CHOOSECOLS(arr,2))),CHOOSECOLS(outarr,1)&"-"&CHOOSECOLS(outarr,2)&"-"&CHOOSECOLS(outarr,3)))
H22:L26	H22	=TRANSPOSE(LET(outarr,LET(arr,WRAPROWS(TEXTSPLIT(TEXTJOIN("-",,TOROW((B2:F2)&"-"&TRANSPOSE(H15#))),"-")*1,4),FILTER(arr,CHOOSECOLS(arr,1)<CHOOSECOLS(arr,2))),CHOOSECOLS(outarr,1)&"-"&CHOOSECOLS(outarr,2)&"-"&CHOOSECOLS(outarr,3)&"-"&CHOOSECOLS(outarr,4)))
Dynamic array formulas.

Thank you very much.
I tried it and it works fine.
Thanks again.

 

[caneki]

Alternative formula for the Pairs and Triplet helpers, similar to used for Quads.

AutoTraining.xlsm
	A	B	C	D	E	F	G	H	I	J	K
20	Pairs Helper	3-15	3-18	3-25	3-28	15-18	15-25	15-28	18-25	18-28	25-28
21	Numbers Pairs	2-5	2-16	2-35	2-45	5-16	5-35	5-45	16-35	16-45	35-45
22		5-25	5-28	5-36	5-38	25-28	25-36	25-38	28-36	28-38	36-38
23		8-16	8-35	8-37	8-45	16-35	16-37	16-45	35-37	35-45	37-45
24		4-10	4-19	4-20	4-43	10-19	10-20	10-43	19-20	19-43	20-43
25	Check Pairs	10-16	10-19	10-20	10-43	16-19	16-20	16-43	19-20	19-43	20-43
26
27
28	Triplets Helper	3-15-18	3-15-25	3-15-28	3-18-25	3-18-28	3-25-28	15-18-25	15-18-28	15-25-28	18-25-28
29	Numbers Triplets	2-5-16	2-5-35	2-5-45	2-16-35	2-16-45	2-35-45	5-16-35	5-16-45	5-35-45	16-35-45
30		5-25-28	5-25-36	5-25-38	5-28-36	5-28-38	5-36-38	25-28-36	25-28-38	25-36-38	28-36-38
31		8-16-35	8-16-37	8-16-45	8-35-37	8-35-45	8-37-45	16-35-37	16-35-45	16-37-45	35-37-45
32		4-10-19	4-10-20	4-10-43	4-19-20	4-19-43	4-20-43	10-19-20	10-19-43	10-20-43	19-20-43
33	Check Triples	10-16-19	10-16-20	10-16-43	10-19-20	10-19-43	10-20-43	16-19-20	16-19-43	16-20-43	19-20-43
Sheet11 (2)

Cell Formulas
Range	Formula
B20:B24	B20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2}))
C20:C24	C20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,3}))
D20:D24	D20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,4}))
E20:E24	E20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,5}))
F20:F24	F20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,3}))
G20:G24	G20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,4}))
H20:H24	H20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,5}))
I20:I24	I20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{3,4}))
J20:J24	J20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{3,5}))
K20:K24	K20	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{4,5}))
B25	B25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2}))
C25	C25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,3}))
D25	D25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,4}))
E25	E25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,5}))
F25	F25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,3}))
G25	G25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,4}))
H25	H25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,5}))
I25	I25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{3,4}))
J25	J25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{3,5}))
K25	K25	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{4,5}))
B28:B32	B28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2,3}))
C28:C32	C28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2,4}))
D28:D32	D28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,2,5}))
E28:E32	E28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,3,4}))
F28:F32	F28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,3,5}))
G28:G32	G28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{1,4,5}))
H28:H32	H28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,3,4}))
I28:I32	I28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,3,5}))
J28:J32	J28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{2,4,5}))
K28:K32	K28	=TEXTJOIN("-",,INDEX(SORT($B2:$F2,,1,TRUE),{3,4,5}))
B33	B33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2,3}))
C33	C33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2,4}))
D33	D33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,2,5}))
E33	E33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,3,4}))
F33	F33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,3,5}))
G33	G33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{1,4,5}))
H33	H33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,3,4}))
I33	I33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,3,5}))
J33	J33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{2,4,5}))
K33	K33	=TEXTJOIN("-",,INDEX(SORT($U$2:$Y$2,,1,TRUE),{3,4,5}))

Thank you so much for your attention to detail.
I'm very happy to apply the function you sent me.
Thank you very much.