Compare 3 Columns excel [Solved/Closed]

Lookup - Mar 16, 2010 at 08:37 PM - Latest reply:  Lookup
- Mar 16, 2010 at 09:35 PM
Hello,

I have to compare 3 columns (A,B AND C) filled with names and return, in another column (E), the list adding the names from the 3 columns (A+B+C-AB-AC-BC-ABC). The problem is that I have to exclude all duplicated names from the final list.

How do I do that?
See more 

2 replies

venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Mar 16, 2010 at 09:25 PM
+2
Helpful
1
quote
dding the names from the 3 columns (A+B+C-AB-AC-BC-ABC).
unquote
this is not clear

I have given a solution for similar problem for two columns in t\

http://ccm.net/forum/affich-287755-compare-two-columns-and-delete-duplicates

see whether you can modify that solution to suit you
in an empty columns(row 1 is having colulmn heading ) e.g.F2
type the formula A2&B2&C2
and copy F2 down

Modify the macro there (changing E to F) and run the macro

first do this solution (concatenating and running the macro) on a sample data.
Was this answer helpful?  
Sorry, it is unclear.

The problem I have is this: I have three lists with 50 names each. I have to create another list in which I will have all the names os the other lists apart from duplicated ones. So the last list won`t necessarily have 150 names, because there are names that can be duplicated in the other columns. So what I need is to Add taking away the intersections you see?

Although it may seem harder, I would like to do it without using macros, just formulas from the excel. Is that possible?