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
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) |