Hi,
I would like to compare a list of values in column B against a list of values on every row in column M contained within a single comma delimited cell. There are somewhere in the region of 3000 rows so i want to avoid manually transposing a row at a time to find duplicates.
What i'm looking to do is match each of the comma delimited values in column M against the individual values on every row in column B.
For every row where all values in Column M are matched against values in column B i want a to return a TRUE value in column O. If any values are not found in column B i want to return a FALSE value in column O.
<TBODY>
</TBODY>
Any help very much appreciated.
I would like to compare a list of values in column B against a list of values on every row in column M contained within a single comma delimited cell. There are somewhere in the region of 3000 rows so i want to avoid manually transposing a row at a time to find duplicates.
What i'm looking to do is match each of the comma delimited values in column M against the individual values on every row in column B.
For every row where all values in Column M are matched against values in column B i want a to return a TRUE value in column O. If any values are not found in column B i want to return a FALSE value in column O.
Colum B | Column M | Column O |
Peter | Peter, David, Claire | FALSE |
David | Paul, Peter, David, Claire, Thomas | TRUE |
Paul | Thomas | FALSE |
Thomas | Thomas, Claire, Peter | FALSE |
Claire | Peter | FALSE |
<TBODY>
</TBODY>
Any help very much appreciated.