Thread: Excel Experts
View Single Post
Old 11-15-2007, 02:57 AM  
WiredGuy
Pounding Googlebot
 
Industry Role:
Join Date: Aug 2002
Location: Canada
Posts: 34,490
Excel Experts

This seems like such a simple operation but it has me stumped, even after googling it. Anyone know how to accomplish this in Excel?

Column A: List of keywords
Column B: Another list of keywords

I want Column C to contain a merged list of the keywords in A and B which would keep only the unique keywords (remove duplicates).

Example:
ColumnA: a, b, c
ColumnB: c,d,e
ColumC: a, b, c, d, e

It seems simple enough, but I'm having a hard time finding out how to do it.

Thanks
WG
__________________
I play with Google.
WiredGuy is online now   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote