IF, OR, CONCATENATE Formula

[Marcia O]

I entered the following formula and the only way I get the
result of each cell that doesn't have "xxxxx" is to fill
in all cells; I want the result cell by cell, can you help?

=IF(OR
(C5="xxxxx",L5="xxxxx",U5="xxxxx",AD5="xxxxx",AM5="xxxxx"),
"",CONCATENATE(C5&", ",L5&", ",U5&", ",AD5&", ",AM5))

 

[Frank Kabel]

Hi
not quite sure what your expected result is. Could you give an example?

 

[Don Guillett]

I'm not sure I understand but
=if(c5="xxxxx",c5,"")+next one+next one

 

[Guest]

Hi Grank

Yes, if C5= "xxxxx", I want a blank, if it =12345, I want
that result. If L5 has x's, I want a blank, but if U5 has
#'s in it, I would like that result right after the C5
results. If #'s are in all cells, with the formula I have
now, I only get the result after I put numbers in EACH
cell, does that make sense? Thank you again and again!

 

[Frank Kabel]

Hi
but if two or more cells met your condition (<>"XXXX") do you want them
concatenated?

 

[Guest]

First, than you for your time, it is truly appreciated.
I don't know if this makes it any clearer.
If C5= "xxxxx", I want a blank, if it =12345, I want
that result. If L5 has x's, I want a blank, but if U5 has
#'s in it, I would like that result right after the C5
results. If #'s are in all cells, with the formula I have
now, I only get the result after I put numbers in EACH
cell, does that make sense? Thank you again and again!

 

[Guest]

Sorry for calling you Grank, bad day Mr. FRANK! yes, that
is exactly what I would like, with a comma in between, not
asking for too much am i?

 

[Frank Kabel]

Hi
try the following:
Download the free add-in Morefunc.xll as you want to combine the
results in one cell
(http://longre.free.fr/english/)

Now use the following array formula entered with CTRL+SHIFT+ENTER):
MCONCAT(IF((MOD(COLUMN(C5:AM5)-3,9)=0)*(C5:AM5<>"xxxxx"),C5:AM5),",")

 

[Don Guillett]

I guess my answer is the same
=if(c5="xxxxx","",c5)+if(l5="xxxx","",l5)+etc

 

[Guest]

Thank you again Frank, and Happy Holiday to you!

-----Original Message-----
Hi
try the following:
Download the free add-in Morefunc.xll as you want to combine the
results in one cell
(http://longre.free.fr/english/)

Now use the following array formula entered with CTRL+SHIFT+ENTER):
MCONCAT(IF((MOD(COLUMN(C5:AM5)-3,9)=0)*

 

[Guest]

I'll give that a shot. Thank you. Thank you. Thank you.

 

[Guest]

Frank,

If I download this file, I share the workbook out, if
people I share it with don't have it downloaded, will it
still give the result?

 

[Frank Kabel]

Hi
no they also need this download. In this case you may use Don'
suggestion

 

[Guest]

Thank you. Unfortunately, it doesn't work. I think I'll
leave well enough alone.