CSE problem

[MikeyZ]

I opened a file I sent to my work, from home.
When I opened it and tried to add to it, I'm gettintg a #NAME? error after I enter the following and hit CSE (Ctrl Shift Enter)

=SUBSTITUTE(MCONCAT(IF(INDEX(D57:CG57,MATCH(B57,B57:B57,0),0)="X",","&$D$7:$CF$7,"")),",","",1)

And I can't figure out why.

Can anyone help?

 

[Andrew Poulsom]

Have you installed the MoreFunc Add-In?

 

[MikeyZ]

Hmmm Most Lilkely not.
I'll search for it and add it in.
Thnx.

 

[MikeyZ]

MoreFunc worked.
Thnx