Hey guys, I'm new here and I have something urgent that needs to be solved.
I'm a webmaster and I received a real messy report from one of my staff.
The goal here is to remove any duplicate "words" from one row to another.
For instance:
A1 | B1 | C1
------------------------------- |-------------------------------------|-------------------
http://dir.yahoo.com |http://video.yahoo.com |http://www.google.com
http://www.google.com|http://www.bing.com |http://www.bing.com
http://excelforum.com/|http://lol.excelforum.com|
http://www.excelforum.com/members/teylyn.html|http://www.excelforum.com/members/seng8.html|
So I want C1 to have unique values only... omitting values that exist 2 times on A1 and B1 cells.
Like for the case of the above illustration, because A2 has the word "yahoo" in it and so is A3... it won't be displayed in C1 cell.
Is there a code in excel to do this? I tried using the "Filter" feature but it didn't help...
Bookmarks