Compare 3 Columns excel
Solved/Closed
Related:
- Compare 3 Columns excel
- Comparing data in 3 columns on a Microsoft Excel spreadsheet ✓ - Forum - Excel
- Compare two columns in excel for partial matches - How-To - Excel
- How To Compare Two Columns in Excel - How-To - Excel
- Excel - Comparing two columns - How-To - Excel
- Comparing two columns of names in Excel ✓ - Forum - Excel
1 reply
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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\
https://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.
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\
https://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.
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?