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