Desperatley looking for Excel formula/macro help

Hi everyone,

I am looking for some help with a formula/macro. In the attached file, i have written a short explanation about what I’m trying to achieve, however, it is also listed below.

In essence, I am trying to create a formula/macro that can tell when there is a duplicate value in column A, if there is a duplicate value in column A, it will return the value in Column A & Column B and so on.

For example, for cells A29&A30, they are duplicate values up until column D when you split text to columns, I need the formula to recognise this and return the words until we are left with a unique name.

With the unique name column (D) this is where I want the unique name to be placed, so that by the end we should be left with a list of completely unique names, for example, column D should read something like this:

Aerocrine – because it is unique, but for aluminium Bahrain, it will return both the values in cells A155&156.

I will be helpful for any help you can provide,

Many thanks

Excel Help 1.xlsExcel Help 1.xls