Formula

[Mitchjack]

I am in need Of a formula that would be something like this thanks for your help
If columb B are = then combine columb A

 

[etaf]

are you still using 2010 version

what happens if left is repeated further down the list
say between the right and up ?
say with G
would that then be
a,b,c,d,g
OR
just G later in the list if 1 only

 

[Peter_SSs]

are you still using 2010 version

I'm thinking most likely since the OP only joined the forum a few hours before posting so would have only just entered that information.

@Mitchjack
Welcome to the MrExcel board!

Could use use something like column C below?
If not could you use that as a helper column (you could hide the column) and then use that to produce what I have in column D?

23 11 19.xlsm
	A	B	C	D
1	Value	Category
2	A	Left	ABCD	ABCD
3	B	Left	BCD
4	C	Left	CD
5	D	Left	D
6	E	Right	EFG	EFG
7	F	Right	FG
8	G	Right	G
9	H	Up	HIJ	HIJ
10	I	Up	IJ
11	J	Up	J
Combine

Cell Formulas
Range	Formula
C2:C11	C2	=A2&IF(B2=B3,C3,"")
D2:D11	D2	=IF(B2=B1,"",C2)

 

[Mitchjack]

are you still using 2010 version

what happens if left is repeated further down the list
say between the right and up ?
say with G
would that then be
a,b,c,d,g
OR
just G later in the list if 1 only

It would be a,b,c,d,,g

 

[Mitchjack]

I'm thinking most likely since the OP only joined the forum a few hours before posting so would have only just entered that information.

@Mitchjack
Welcome to the MrExcel board!

Could use use something like column C below?
If not could you use that as a helper column (you could hide the column) and then use that to produce what I have in column D?

23 11 19.xlsm
	A	B	C	D
1	Value	Category
2	A	Left	ABCD	ABCD
3	B	Left	BCD
4	C	Left	CD
5	D	Left	D
6	E	Right	EFG	EFG
7	F	Right	FG
8	G	Right	G
9	H	Up	HIJ	HIJ
10	I	Up	IJ
11	J	Up	J
Combine

Cell Formulas
Range	Formula
C2:C11	C2	=A2&IF(B2=B3,C3,"")
D2:D11	D2	=IF(B2=B1,"",C2)

D2 is what I think I’m looking for thank you

 

[Peter_SSs]

It would be a,b,c,d,,g

Does that mean you need something more like this?

23 11 19.xlsm
	A	B	C	D
1	Value	Category	Helper	Result
2	A	Left	ABCDX	ABCDX
3	B	Left	BCDX
4	C	Left	CDX
5	D	Left	DX
6	E	Right	EFG	EFG
7	F	Right	FG
8	X	Left	X
9	G	Right	G
10	H	Up	HIJ	HIJ
11	I	Up	IJ
12	J	Up	J
Combine (2)

Cell Formulas
Range	Formula
C2:C12	C2	=A2&IFERROR(VLOOKUP(B2,B3:C$20,2,0),"")
D2:D12	D2	=IF(COUNTIF(B$2:B2,B2)=1,C2,"")

 

[Mitchjack]

Does that mean you need something more like this?

23 11 19.xlsm
	A	B	C	D
1	Value	Category	Helper	Result
2	A	Left	ABCDX	ABCDX
3	B	Left	BCDX
4	C	Left	CDX
5	D	Left	DX
6	E	Right	EFG	EFG
7	F	Right	FG
8	X	Left	X
9	G	Right	G
10	H	Up	HIJ	HIJ
11	I	Up	IJ
12	J	Up	J
Combine (2)

Cell Formulas
Range	Formula
C2:C12	C2	=A2&IFERROR(VLOOKUP(B2,B3:C$20,2,0),"")
D2:D12	D2	=IF(COUNTIF(B$2:B2,B2)=1,C2,"")

Yes that is what I’m looking for Thank You very much

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.