Identify Uniques Names Associated with a Country

[Taisir]

Dear Friends
I am looking for a VBA/Macro to pick up unique names associated with a specific country, Saudi Arabia for example from each record.

The attached sample sheet includes the records in Column A and the desired output/outcome from the needed VBA are listed starting in column “B” rightward as needed..
All names associated with Saudi Arabia or any other country are listed within brackets “[ ]”.
Please note that I need the unique list of names (i.e., without duplicates). See the last record

Thanks in advance Taisir

[huuthang_bd]

Try this

Please Login or Register  to view this content.

[Taisir]

Dear huutahng_bd
Many thanks for the VBA. It seems it does a good job indeed, Will test it in large numbers of record and will get back to you in case I need further help. All the best

[huuthang_bd]

You are welcome. Thank you for adding reputation.