CONCATENATE cells if other cells are the same

M

Mally

Hi

If cells A1:A3 are the same then I want to CONCATENATE cells B1:B3 into
cells E1:E3 and C1:C3 into F1:F3
e.g.
A B C D E F
1 1 B A B A
2 2 S E S D E Q
3 2 D Q
4 5 L D L D
5 8 S T S A T Z
6 8 A Z

I need to copy this formula down my worksheet.

Thanks in advance for any help.
 
M

Mally

This should read

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
e.g.
A B C D E
1 1 B A B A
2 2 S E S D E Q
3 2 D Q
4 5 L D L D
5 8 S T S A T Z
6 8 A Z

I need to copy this formula down my worksheet.

Thanks in advance for any help.
 
R

Ron Coderre

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,B4,"")

Copy that formula across and down through E7.

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)
 
M

Mally

Thanks Ron. Thats what i wanted with the exception if 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top