Inserting Values In Existing Formula

[CARBOB]

I need to replace the values in the braces with the values in Column A. Is there an easy way to do this or am I stuck with doing each one manually? There are 92 lines in Column A. Thanks for any suggestions.

FL LOTTO 6-53.xlsx
	A	B	C	D
1
2
3	7,13,38,17,29,30,44	0
4	47,8,33,41,24,23,28
5	37,13,5,32,26,6,8
6	22,23,33,34,39,42,16
7	36,25,37,20,43,34,31
Sheet3

 

[onlyadrafter]

Hello,

I think this is correct, however you need to add a , at the beginning and at the end of the numbers in COl A

=SUMPRODUCT(--ISNUMBER(FIND(","&TEXT($B5:$G5,"@@")&",",A3:A7)))

change A3:A7 as required

 

[Andrew Poulsom]

Building on onlyadrafter's formula, I think:

=SUMPRODUCT(--ISNUMBER(FIND(","&$B5:$G5&",",","&A3&",")))

will do the job.

 

[CARBOB]

Building on onlyadrafter's formula, I think:

=SUMPRODUCT(--ISNUMBER(FIND(","&$B5:$G5&",",","&A3&",")))

will do the job.

Thanks to both of you for responding. I might be misunderstanding, here are the results

FL LOTTO 6-53.xlsx
	A	B	C	D	E	F	G	H
3	5	6	9	25	39	41	7,13,38,17,29,30,44	0
Sheet3

Change this

SUMPRODUCT(--ISNUMBER(MATCH($B5:$G5,{25,50,22,48,21,49,24,53,29,5,35,12,43,23,4,38,18,3,40,27,11},0)))

To this
SUMPRODUCT(--ISNUMBER(MATCH($B5:$G5,{7,13,38,17,29,30,44},0)))

 

[Andrew Poulsom]

Do you have a problem with the result? None of the numbers in A3:F3 appear in G3, so the result of zero is correct isn't it?

 

[CARBOB]

Do you have a problem with the result? None of the numbers in A3:F3 appear in G3, so the result of zero is correct isn't it?

Sorry Mr Poulson, misunderstood the results. Thank you!!!

 

[CARBOB]

The formula in SW5 counts the number of matches found in Col's ST:SV. The formula counts duplicate digits as 2. I need a formula that counts duplicate(0,0,7) or triple(5,5,5)digits as 1.

CASH3 MID 100GROUP COMBO SUMS WITH HORS.xlsx
	SS	ST	SU	SV	SW
5					0,1,2,5,8
6	03/17/09	2	1	8	3
7	03/16/09	0	0	7	2
8	03/15/09	4	5	5	2
Sheet1

 

[Andrew Poulsom]

Try:

=SUMPRODUCT(--ISNUMBER(FIND(","&$ST6:$SV6&",",","&SW$5&",")),1/COUNTIF($ST6:$SV6,$ST6:$SV6))

 

[CARBOB]

Fantastic Mr Poulson, Thank You

Try:

=SUMPRODUCT(--ISNUMBER(FIND(","&$ST6:$SV6&",",","&SW$5&",")),1/COUNTIF($ST6:$SV6,$ST6:$SV6))

 

[CARBOB]

I have a question about this formula

=SUMPRODUCT(--ISNUMBER(FIND(","&DRAWS!$B$3:$G$3&",",","&$L6505&",")))
in column M6505, it's returning a value of 4 when comparing this string 34,45,08,37,31,07,48 to these values 8 16 31 37 45 48 and it should return 5.

FL LOTTO 6-53.xlsx
	L	M	N	O
6505	34,45,08,37,31,07,48	4	1	1
Sheet3