IF, OR, CONCATENATE Formula

  • Thread starter Thread starter Marcia O
  • Start date Start date
M

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))
 
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!
 
Hi
but if two or more cells met your condition (<>"XXXX") do you want them
concatenated?
 
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!
 
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?
 
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),",")
 
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)*
Click to expand...
 
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?
 
Back
Top