concatenate identical cells

[johnny52]

I have identical data in cells A2 and B2 in cell c2 I would like to concatenate them but only showing one.....like if(a2=b2,a2,"") and if(a2=b2,b2,"") won't work to put in cell c2.

I was trying a trim formula but not having any luck....I think I'm making this harder than it should be

Something like this....but obviously (not to me) isn't working

=TRIM(A2&IF(COUNTIF(A2:B2,A2)>1,"",","&B2)&IF(COUNTIF(A2:B2,B2)>1,"",","&B2))

Thanks everybody

 

[Fluff]

I would like to concatenate them but only showing one

This seems to me to be contradictory, if you only want to show one value, then you do not need to concatenate them.
Can you please post some sample data & expected outcome, using the XL2BB add-in.

 

[etaf]

I have identical data in cells A2 and B2 in cell c2 I would like to concatenate them but only showing one.....like if(a2=b2,a2,"") and if(a2=b2,b2,"") won't work to put in cell c2.

if A2 and B2 are the same then you only need to return either A2 or B2
so =IF( A2=B2, A2, "")

why does that not work
if they are not = then concatenate

so =IF( A2=B2, A2, A2&B2)

 

[johnny52]

=IF( A2=B2, A2, A2&B2)

This seems to me to be contradictory, if you only want to show one value, then you do not need to concatenate them.
Can you please post some sample data & expected outcome, using the XL2BB add-in.

ok

I put this formula into the worksheet and it worked......still think you were right....but when I concatenated the two cells with the same identical content, they both appeared (duplicated) in the new cell with the earlier formulas I mentioned. Not sure why...but it worked with this one.

Thanks everybody.

=IF(G1=H1,CONCATENATE($G1,IF(EXACT($G1,$H1),"")),CONCATENATE(G1,H1))

 

[johnny52]

if A2 and B2 are the same then you only need to return either A2 or B2
so =IF( A2=B2, A2, "")

why does that not work
if they are not = then concatenate

so =IF( A2=B2, A2, A2&B2)

ok

I put this formula into the worksheet and it worked......still think you were right as well....but when I concatenated the two cells with the same identical content, they both appeared (duplicated) in the new cell with the earlier formulas I mentioned. Not sure why...but it worked with this one.

Thanks everybody.

=IF(G1=H1,CONCATENATE($G1,IF(EXACT($G1,$H1),"")),CONCATENATE(G1,H1))

 

[etaf]

you are welcome