Hello Friends,
I am using the below formula (Column C) which I also got it form this useful site..
Is there any possibility to have the results as stated in column D
I am using the below formula (Column C) which I also got it form this useful site..
Is there any possibility to have the results as stated in column D
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | REF # | PO # | Concatenated Values | Required | ||
2 | 1 | 123456 | 123456 | 123456 | ||
3 | 1 | 123457 | 123456 - 123457 | 123456 - 7 | ||
4 | 1 | 123490 | 123456 - 123457 - 123490 | 123456 - 7 - 90 | ||
5 | 2 | 234909 | 234909 | 234909 | ||
6 | 2 | 234876 | 234909 - 234876 | 234909 - 876 | ||
7 | 2 | 123456 | 234909 - 234876 - 123456 | 234909 - 876 - 123456 | ||
8 | 3 | 345678 A | 345678 A | 345678 A | ||
9 | 3 | 345678 B | 345678 A - 345678 B | 345678 A - B | ||
10 | 3 | 345678 C | 345678 A - 345678 B - 345678 C | 345678 A - B - C | ||
11 | 4 | 123456 | 123456 | 123456 | ||
12 | 4 | 388618 | 123456 - 388618 | 123456 - 388618 | ||
13 | 4 | 123457 | 123456 - 388618 - 123457 | 123456 - 388618 - 123457 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2:C13 | C2 | =IF(A2<>A1,B2,IF(ISNUMBER(SEARCH(B2,C1)),C1,C1&" - "&B2)) |