#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.

[TABLE="class: grid, width: 384"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]o/e[/TD]
[TD="width: 64, bgcolor: transparent"]h/l[/TD]
[TD="width: 64, bgcolor: transparent"]i/o[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent"]OOO[/TD]
[TD="bgcolor: transparent"]HHL[/TD]
[TD="bgcolor: transparent"]IIO[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]7[/TD]
[TD="bgcolor: transparent"]EOO[/TD]
[TD="bgcolor: transparent"]LHH[/TD]
[TD="bgcolor: transparent"]OII[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

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]

[TABLE="class: grid, width: 384"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]o/e[/TD]
[TD="width: 64, bgcolor: transparent"]h/l[/TD]
[TD="width: 64, bgcolor: transparent"]i/o[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent"]OOO[/TD]
[TD="bgcolor: transparent"]HHL[/TD]
[TD="bgcolor: transparent"]IIO[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]7[/TD]
[TD="bgcolor: transparent"]EOO[/TD]
[TD="bgcolor: transparent"]LHH[/TD]
[TD="bgcolor: transparent"]OII[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

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?