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

 

[AlphaFrog]

Re: MoreFunc for Excel 2010

 

[CARBOB]

Installed Morefunc 11 & 12 in C:Program Files(x86). Same results.

 

[CARBOB]

Installed Morefunc 11 & 12 in C:Program Files(x86). Same results.

Does anyone on the forum use Office 365 and have Morefunc installed and working?

 

[Aladin Akyurek]

Does anyone on the forum use Office 365 and have Morefunc installed and working?

Try to switch to TEXTJOIN, a native Excel function or to a workalike udf ACONCAT...

{=TEXTJOIN("",TRUE,​

IF(MOD((MID($I21,{1,2,3},1)+0),2)=0,"E","O")​

)}​

 

[CARBOB]

Does anyone on the forum use Office 365 and have Morefunc installed and working?

Fantastic, this forum is the best! Many thanks!!!

 

[CARBOB]

Try to switch to TEXTJOIN, a native Excel function or to a workalike udf ACONCAT...

{=TEXTJOIN("",TRUE,​

IF(MOD((MID($I21,{1,2,3},1)+0),2)=0,"E","O")​

)}​

How do I get the formula to work with these values,
0,1,2,3,4 =L
5,6,7,8,9 =H

3,4,5,6,7 = I
0,1,2,8,9 = O

I tried this, but get a error message.
=TEXTJOIN("",TRUE,IF(MOD((MID($E21,{1,2,3},1)+0)<5,=0,"L","H"))

 

[Aladin Akyurek]

How do I get the formula to work with these values,
0,1,2,3,4 =L
5,6,7,8,9 =H

3,4,5,6,7 = I
0,1,2,8,9 = O

I tried this, but get a error message.
=TEXTJOIN("",TRUE,IF(MOD((MID($E21,{1,2,3},1)+0)<5,=0,"L","H"))

Care to post a tiny sample along with the desired results? (just that, no formulas)

 

[CARBOB]

how do i get the formula to work with these values,
0,1,2,3,4 =l
5,6,7,8,9 =h

3,4,5,6,7 = i
0,1,2,8,9 = o

i tried this, but get a error message.
=textjoin("",true,if(mod((mid($e21,{1,2,3},1)+0)<5,=0,"l","h"))

551 ooo hhl iio
057 eoo lhh oii

 

[Aladin Akyurek]

What does

551 ooo hhl iio​

mean?