View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Display only unique values in CONCATENATE formula

If you're existing formula works ok:
=IF($A2<$A1,B2,"")&IF($A2=$A3,B3,"")&IF($A2=$A4,B 4,"")
then change those empty strings "" to a space character " "
=IF($A2<$A1,B2," ")&IF($A2=$A3,B3," ")&IF($A2=$A4,B4," ")

But this means you could have something like:
Yes Yes Traffic

So wrap it =trim() to get rid of the leading, trailing and multiple embedded
spaces:

=trim(IF($A2<$A1,B2," ")&IF($A2=$A3,B3," ")&IF($A2=$A4,B4," "))



Mally wrote:

Thank you to Excel MVP Ron Coderre for the following formula. This is to
used to show if cells A1:A3 are the same then I want to CONCATENATE cells
B1:B3 into
cells D1:D3 and C1:C3 into E1:E3

If Row_1 can contain headings and your data can start in Row_2...
Try this:
D2: =IF($A2<$A1,B2,"")&IF($A2=$A3,B3,"")&IF($A2=$A4,B 4,"")

Some cells contain the same words then these are repeated. Is it possible
for just one of unique values to be displayed. Currently my results look
like this

YesYesYesYesTrafficTraffic

I want it to look like this

Yes Traffic

with a space in between

etc.

Thank you again


--

Dave Peterson