if statement + concantenate

[jlugo]

Hi,

What formula would satisfy these parameters (if statement + concantenate):

If f5=h5 then display only f5, if not, display the concantenation of f5 + " " + h5


Thanks!

 

[Aladin Akyurek]

Hi,

What formula would satisfy these parameters (if statement + concantenate):

If f5=h5 then display only f5, if not, display the concantenation of f5 + " " + h5


Thanks!

=if(f5=h5,f5,f5&" "&h5)

 

[ZAX]

Use the following formula:

=IF(H5=F5,F5,F5&" "&H5)

ZAX

 

[jlugo]

OMG lifesavers!!!!!!!!!!!! Thanks so much.

 

[jlugo]

Ok wait, I spoke too soon.
Some fields that are the same value are combining "205 205". No spaces so not sure what's is the problem? I made sure both columns were converted to text.

 

[Aladin Akyurek]

Ok wait, I spoke too soon.
Some fields that are the same value are combining "205 205". No spaces so not sure what's is the problem? I made sure both columns were converted to text.

Does...

=if(trim(f5)=trim(h5),trim(f5),trim(f5&" "&h5))

escape the problem?

 

[BenMiller]

Does...

=if(trim(f5)=trim(h5),trim(f5),trim(f5&" "&h5))

escape the problem?

You could probably shorten that to

=trim(if(trim(f5)=trim(h5),f5,f5&" "&h5))

 

[jlugo]

It made a huge difference.

One more criteria.

If the new concatenated column has a number that shows up more than once on either the column on the left or on the right of the new one, then just display the repeating number instead of concatenating the two.
How would we modify this to that?

Goal is to get expenses together creating some unique identifier but still grouping those with the same identifier.

 

[Aladin Akyurek]

It made a huge difference.

One more criteria.

If the new concatenated column has a number that shows up more than once on either the column on the left or on the right of the new one, then just display the repeating number instead of concatenating the two.
How would we modify this to that?

Goal is to get expenses together creating some unique identifier but still grouping those with the same identifier.

Would you try to exemplify?