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

danderson1, I am sorry to ding you on your first post but as a new member I suggest you take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good thread titles. You have posted to a VBA subforum and every question is asking for macro help. Please update your title to something that gives some insight to your specific question.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi,

It would have been sufficient, as 6String.. said to edit your title. You appear to have opened up a new thread entirely. viz: http://www.excelforum.com/excel-prog...a-problem.html

Normally I'd close that one being the latest and leave this one. However since you've received a response on the other I'll close this instead. However please note for the future both rules, the one about titles and the other about duplicates.