Check previous powerball results with your numbers

[askall1000]

Hi,
Can you help me for the desired result for the column highlighted green. Thank you very much in advance. And please don't play the numbers

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
2									my numbers
3									1	2	3	4	5	6
4									2	3	4	5	6	7
5									3	4	5	6	7	8
6									4	5	6	7	8	9
7									5	6	7	8	9	10
8									11	12	13	14	15	16
9	Previous Results						Requested result
10	1	2	3	4	5	6	5+1
11	56	57	58	25	26	7	0+1
12	2	3	4	5	6	8	5+0
Sheet1

 

[JEC]

Why is the yellow eight a zero? If your own numbers are sorted ascending like in your sample, this will work

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1									my numbers
2									1	2	3	4	5	6
3									2	3	4	5	6	7
4									3	4	3	6	7	8
5									4	5	6	7	8	9
6									5	6	7	8	9	10
7									11	12	13	14	15	16
8
9	Previous Results						Requested result
10	1	2	3	4	5	6	5+1	5+1
11	56	57	58	25	26	7	0+1	0+1
12	2	3	4	5	6	8	5+0	5+1
13	….
Sheet1

Cell Formulas
Range	Formula
H10:H12	H10	=MAX(MMULT(IF(SORT(A10:E10,,,1)=$I$2:$M$7,1,0),{1;1;1;1;1}))&"+"&COUNTIF($N$2:$N$7,F10)

 

[JEC]

Both the results as your numbers could be unsorted here

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1									my numbers
2									1	5	3	4	2	6
3									2	3	4	5	6	7
4									3	7	3	6	4	8
5									4	5	6	7	8	9
6									5	6	8	7	9	10
7									14	12	15	11	13	16
8
9	Previous Results						Requested result
10	1	2	3	4	5	6	5+1	5+1
11	56	57	58	25	26	7	0+1	0+1
12	2	3	4	5	6	8	5+0	5+1
Sheet1

Cell Formulas
Range	Formula
H10:H12	H10	=MAX(MMULT(COUNTIF(A10:E10,$I$2:$N$7),{1;1;1;1;1;1}))&"+"&COUNTIF($N$2:$N$7,F10)

 

[askall1000]

Why is the yellow eight a zero? If your own numbers are sorted ascending like in your sample, this will work

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1									my numbers
2									1	2	3	4	5	6
3									2	3	4	5	6	7
4									3	4	3	6	7	8
5									4	5	6	7	8	9
6									5	6	7	8	9	10
7									11	12	13	14	15	16
8
9	Previous Results						Requested result
10	1	2	3	4	5	6	5+1	5+1
11	56	57	58	25	26	7	0+1	0+1
12	2	3	4	5	6	8	5+0	5+1
13	….
Sheet1

Cell Formulas
Range	Formula
H10:H12	H10	=MAX(MMULT(IF(SORT(A10:E10,,,1)=$I$2:$M$7,1,0),{1;1;1;1;1}))&"+"&COUNTIF($N$2:$N$7,F10)

Yes, you are right, omitted it. thank you very much your help, if i win, i will treat you whatever you want! Promise!!

 

[JEC]

haha goodluck! And you are welcome