column formula - help needed!

[canucksguy]

Hello everyone,

First time post here. Basically i have a database with names of peopl
in, say column A, B, and C (I am dumbing this down a little fo
simplicity's sake). Basically I want to create a new column tha
outputs something like "NameA, NameB, NameC". However in many cases
for example, a NameC won't exist, and I then want it to read "NameA
NameB". See what I am getting at? I only want it to display (an
format accordingly) if the corresponding name cell isnt blank.

Any thoughts?


Mik

 

[JulieD]

Hi

not 100% sure what you're after but how about
where your names start in A1 - you can then fill the formula down for the
other rows

=IF(C1="",A1 & ", " & B1, A1 & ", " & B1 & ", " C1)

Let us know how you go

Cheers
JulieD

 

[corrie]

You could try using an IF statement...

=IF(Condition checking for, value-if-true, value-if-false)
=IF(C1="",'",C1)

Not sure if it would need to be more complex than that... depends o
what you are doing with it

 

[canucksguy]

I did just that of the above post. Unforetunately it became mor
complicated as the names werent the only things to be included
suffixes also existed quite often (stating the person's position).
had up to 10 names but the formula would have been too complicated so
cut it off after three. Even then, take a look at this wooly mammoth:


=IF(BA2="",IF(AY2="",AU2&" "&AV2&" "&AW2&" ("&AX2&")",AU2&" "&AV2&
"&AW2&" ("&AX2&"), "&AY2&" ("&AZ2&")"),AU2&" "&AV2&" "&AW2&" ("&AX2&")
"&AY2&" ("&AZ2&")"&", "&BA2&" ("&BB2&")"

 

[JulieD]

Hi
not sure if this makes things better or worse but an alternative is:
=IF(BA2="",IF(AY2="",CONCATENATE(AU2," ",AV2," ",AW2,"
(",AX2,")"),CONCATENATE(AU2," ",AV2 ... etc

what are you trying to achive with this?

cheers
JulieD

 

[canucksguy]

CONCATENATE would work too, I believe, but I have fixed this and I a
not about to tinker with it now. Working this out for all 10 fields i
probably not worth my while. Thanks guys