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

 

[Aladin Akyurek]

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?

No, already for reasons of efficiency.

 

[CARBOB]

No, already for reasons of efficiency.

Thank you!