Excel Formula - Comine text with formula ignoring duplicates

[hrayani]

Hello Friends,

Please have a look at the below sample data. I would appreciate if someone can provide a formula for this if possible
Currently I am using a UDF concatenateif which works fine but takes a long time to calculate as the actual data is very huge

VBA Working.xlsm
	A	B	C	D
1	REF #	Article	Article Join
2	123	Bed Set	Bed Set	CASE 1
3	123	Bed Set	Bed Set
4	123	Bed Set	Bed Set
5	123	Side Pillow	Bed Set - Side Pillow
6	125	Bed Set	Bed Set	CASE 2
7	125	Fitted Sheet	Bed Set - Fitted Sheet
8	125	Bed Set	Bed Set - Fitted Sheet - Bed Set
9	125	Side Pillow	Bed Set - Fitted Sheet - Bed Set - Side Pillow
10
11		Required in Cell C9	Bed Set - Fitted Sheet - Side Pillow	ignore_duplicate
concat_if-experiment

Cell Formulas
Range	Formula
C2:C9	C2	=IF(OR(A2<>A1,B2=B1),B2,C1&" - "&B2)

 

[Fluff]

How about

=IF(A2<>A1,B2,IF(ISNUMBER(SEARCH(B2,C1)),C1,C1&" - "&B2))

 

[hrayani]

Th

How about

=IF(A2<>A1,B2,IF(ISNUMBER(SEARCH(B2,C1)),C1,C1&" - "&B2))

Thanks Fluff

Working just PERFECT

 

[Fluff]

You're welcome & thanks for the feedback.