Pick up Unique names associated with certain organization

[Taisir]

Dear Friends
I am looking for a VBA/Macro to pick up unique names associated with “King Saud Univ” from each record.
The attached sample sheet includes the records in Column B and the desired output/outcome from the needed VBA are listed starting in column “C” rightward as needed..
All names associated with “King Saud Univ” are listed within brackets “[ ]” preceding the name of the university. Please note that I need the unique list of names (i.e., without duplicates).

Thanks in advance Taisir

[Arkadi]

I noticed your example did have a duplicate name... I assume that was an accident? (row 11)

See if this works for you:

Please Login or Register  to view this content.

[Taisir]

Dear Arkadi
Indeed, it was a mistake in the table. The VBA you sent worked beautifully. I will test on the real data and will let you know.

All the best Taisir

[Arkadi]

Hi Taisir

Thanks for the rep, and I'm glad it seems to be working on the test data. Hopefully it performs as well on the real file
Looking forward to finding out.

[Arkadi]

Taisir,

I got your message about it being case sensitive... we can fix that if the data is not always identical (meaning it will no longer be case sensitive). We just need to change a few lines:

Please Login or Register  to view this content.

becomes:

Please Login or Register  to view this content.

Then change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

and also:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

[Taisir]

Many thanks Arkadi
I took note of that. The exported data almost perfect /uniformed in terms of the name of "king Saud University", there was on 2 cases in more than 2800 records.
FYI, I will be using your VBA for many months and many files for other organizations reserach data. All what I;ve been doing is to change the name of the organization.
I will keep you posted if I need any modification.
Great help indeed

I appreciate your kind help. Taisir