#name?

[CARBOB]

Don't why there is #NAME ? error using the Morefunc (MCONCAT)?

Book1
	N	O	P	Q	R
21	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?
22	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?
23	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?
24	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?	[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?
SKIPSUMS

Cell Formulas
Range	Formula
N21	=M21&R21
R21	=IF(2*LEN(SUBSTITUTE(O21,"E",""))O21),"Y","N")&IF(2*LEN(SUBSTITUTE(P21,"H",""))P21),"Y","N")
O21	{=MCONCAT(IF(MOD((MID($I21,{1,2,3},1)+0),2)=0,"E","O"))}
P21	{=MCONCAT(IF((MID($I21,{1,2,3},1)+0)<5,"L","H"))}
Q21	{=MCONCAT(IF(MOD((MID($I21,{1,2,3},1)+0),8)<3,"O","I"))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[CARBOB]

551 ooo hhl iio
057 eoo lhh oii

e= even
o= odd
I=in
O=Out

 

[Aladin Akyurek]

e= even
o= odd
I=in
O=Out

Is 551 all of these ooo, hhl, and iio?

 

[CARBOB]

Is 551 all of these ooo, hhl, and iio?

Yes

 

[Aladin Akyurek]

Yes

Thanks for the elaborations you provide. Alas, they are Titanese too me.

 

[CARBOB]

Thanks for the elaborations you provide. Alas, they are Titanese too me.

Digits from Cash 3 draws range 0-9
There 1000 combinations ranging from 000-999

o=odd 1,3,5,7,9
e=even 0,2,4,6
h=high 5,6,7,8,9
l=low 0,1,2,3,4
l=in 3,4,5,6,7
O=out 0,1,2,8,9

 

[Aladin Akyurek]

Digits from Cash 3 draws range 0-9
There 1000 combinations ranging from 000-999

o=odd 1,3,5,7,9
e=even 0,2,4,6
h=high 5,6,7,8,9
l=low 0,1,2,3,4
l=in 3,4,5,6,7
O=out 0,1,2,8,9

Is 551 in one cell or in three cells?

 

[CARBOB]

Is 551 in one cell or in three cells?

The values can be in 3 separate cells or in a single cell.

 

[Aladin Akyurek]

The values can be in 3 separate cells or in a single cell.

			o/e	h/l	i/o
5	5	1	OOO	HHL	IIO
0	5	7	EOO	LHH	OII

<tbody>
</tbody>

In D2 control+shift+enter, not just enter, and copy down...

Either:

=TEXTJOIN("",TRUE,IF(ISNUMBER(MATCH(A2:C2,{1,3,5,7,9},0)),"O","E"))

Or:

=TEXTJOIN("",TRUE,IF(ISEVEN(A2:C2+0),"E","O"))

In E2 control+shift+enter, not just enter, and copy down:

=TEXTJOIN("",TRUE,IF(A2:C2>=5,"H","L"))

In F2 control+shift+enter, not just enter, and copy down:

=TEXTJOIN("",TRUE,IF(ISNUMBER(MATCH(A2:C2,{3,4,5,6,7},0)),"I","O"))

 

[CARBOB]

			o/e	h/l	i/o
5	5	1	OOO	HHL	IIO
0	5	7	EOO	LHH	OII

<tbody>
</tbody>

In D2 control+shift+enter, not just enter, and copy down...

Either:

=TEXTJOIN("",TRUE,IF(ISNUMBER(MATCH(A2:C2,{1,3,5,7,9},0)),"O","E"))

Or:

=TEXTJOIN("",TRUE,IF(ISEVEN(A2:C2+0),"E","O"))

In E2 control+shift+enter, not just enter, and copy down:

=TEXTJOIN("",TRUE,IF(A2:C2>=5,"H","L"))

In F2 control+shift+enter, not just enter, and copy down:

=TEXTJOIN("",TRUE,IF(ISNUMBER(MATCH(A2:C2,{3,4,5,6,7},0)),"I","O"))

You have skills that I admire. Thank you very much.

 

[CARBOB]

You have skills that I admire. Thank you very much.

Is it possible to have the last 2 formulas(=TEXTJOIN("",TRUE,IF(A2:C2>=5,"H","L"));(=TEXTJOIN("",TRUE,IF(ISNUMBER(MATCH(A2:C2,{3,4,5,6,7},0)),"I","O") reference the cell $e21 that has all 3 values in a single cell?