Hello,
I'm looking to compare 2 columns on a single sheet that have multiple lines within a single cell (text values). I would like to highlight or pull the missing data of all text in Column A that does NOT show up in Column B (OR highlight/pull data of all the matching text), but since there are multiple values within a single cell, I'm struggling to figure out how to do this.
Example:
*In this example, Henry, Joan and Alice are in a single cell in Column A, and show up in Column B (either singularly in a cell or multiple lines in a cell)...so they should match (be true, etc.)
But Fred would be the missing data - as Fred is listed in Column A but not in Column B. I would like to either highlight or pull the text data of "Fred" showing that there is no match in Column B. Or alternatively, highlight all the matching data between the 2 columns and not the missing data (ie. Henry, Joan, Alice, Peter, Mary).
I have tried conditional formatting and Vlookup, but again, the issue of the multiple lines in a single cell makes it not work the way I'm needing.
Is there any way to do this??
Please help!
Thank you!!!
I'm looking to compare 2 columns on a single sheet that have multiple lines within a single cell (text values). I would like to highlight or pull the missing data of all text in Column A that does NOT show up in Column B (OR highlight/pull data of all the matching text), but since there are multiple values within a single cell, I'm struggling to figure out how to do this.
Example:
| Column A | Column B |
| Henry Joan Alice | John |
| Peter | |
| Mary | Alice |
| Henry Peter | |
| Fred | Joan Mary |
*In this example, Henry, Joan and Alice are in a single cell in Column A, and show up in Column B (either singularly in a cell or multiple lines in a cell)...so they should match (be true, etc.)
But Fred would be the missing data - as Fred is listed in Column A but not in Column B. I would like to either highlight or pull the text data of "Fred" showing that there is no match in Column B. Or alternatively, highlight all the matching data between the 2 columns and not the missing data (ie. Henry, Joan, Alice, Peter, Mary).
I have tried conditional formatting and Vlookup, but again, the issue of the multiple lines in a single cell makes it not work the way I'm needing.
Is there any way to do this??
Please help!
Thank you!!!
