Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching 2 text columns
I did this a long time ago, and it was really easy to do - but I can't
figure it out now... I have two columns of text data...similar to this: BOB BOB JULIE JULIE JEFF JOHN JOHN ED STEVE ED What I want to do is run a comparison between the two columns so it ends up looking like: BOB BOB JULIE JULIE JEFF JOHN JOHN STEVE ED ED Basically, matching column B with column A, and if there isn't a match, just leave it blank, and vice versa. I have about 700 items in each column, and i need to quickly see what the differences are, and all the data is text labels... Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Justify text across multiple columns | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions | |||
Text To Columns | Excel Worksheet Functions |