Extract client names from the list - vba

Hey!

I have the list of clients name. Some names are repeated.
example.
1.Saudi Arabian Saipem
2.NDT Services
3.MMG Group
4.Saudi Bin-Ladin Group(SBG)
5.Saudi Arabian Saipem
6.Saudi Bin-Ladin Group(SBG)
7.MMG Group
8.MMG Group
9.NDT Services.

Here I need to extract the client only once. So the answer should be

1.MMG Group
2.Saudi Arabian Saipem
3.NDT Services
4.Saudi Bin-Ladin Group(SBG)

Can anyone help me in this regard. Thanks in advance.

Charles

Originally Posted by Leith Ross

Hello Charles,

Does this relate to your previous project that I helped you with?

Of course,

I have the old list of four year record. And now I like to use with the project
you helped me.

First I need to extract and form the list of client name from those period
which is about 5 to 6000 records in which one client name was repeated.
After consolidating a client's list, I can make use with new vba program.

Thank you for your kind help.

charles.

Originally Posted by realniceguy5000

Hi,

This assumes your list in Column A

Please Login or Register  to view this content.

It still keeps repeated "A1" value.
The value in cell "A1" is repeating not deleting.

There is 75 client names starts from cell A1 and goes repeated towards the bottom.
I need to remove all repeated client names and keep only 75 clients.

thank you for your help.

charles

Originally Posted by Leith Ross

Hello Charles,

As I understand it, you want to remove duplicate the names in column "A" and import this new list into another workbook. Is that correct?

Exactly.

But no need into another workbook, just another column is enough or
just delete repeated (duplicate) name.

Thank you.
charles

Originally Posted by Leith Ross

Hello Charles,

I though this might change the Data sheet in your project. If you want to place the data in another column then realniceguy5000's solution will work fine. If you need to delete the entire row if a duplicate is found then some adjustment to the macro will be needed.

Yes, I try to delete the duplicate value in row "A",
But I don't think it is easy for me.

I would be much thankful if you can help me.
charles

Originally Posted by Leith Ross

Hello Charles,

Can you post the workbook with the full list that needs to duplicates removed?

Yes ,

Here I attached the file contains partial list.

Can you help me in this file?

charles

Originally Posted by Leith Ross

Hello Charles,

I modified realniceguy5000's macro a little and attached it to a button. here is the revised macro.

Please Login or Register  to view this content.

Thank you very much.

Charles

Originally Posted by Leith Ross

Hello Charles,

I modified realniceguy5000's macro a little and attached it to a button. here is the revised macro.

Please Login or Register  to view this content.

Thank you very much. For your guide.
thank you.

Charles