Hi All,
I have a database which includes different countries names in single cell.
I like to remove the duplicate countries and keep an unique name for each country is enough.
I've attached example file for reference.
Regards
Elango
Hi All,
I have a database which includes different countries names in single cell.
I like to remove the duplicate countries and keep an unique name for each country is enough.
I've attached example file for reference.
Regards
Elango
Please Login or Register to view this content.
Last edited by Marc L; 04-02-2014 at 06:36 PM.
Hi Marc,
Thank you so much for the code. Which is working fine in the example file. Which not working in the data which i have.
My data range starts is from J27 and ends based on the availability of data. I have modified the code, however it is not working
Please help me!!!
Heres another way..
See attachment for working example..
Please Login or Register to view this content.
Hi Apo,
I followed your way it worked perfectly. I really appreciate your help!
Thanks a lot!!!!
Elango
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks