Hello
I need some help with a problem that I am trying to solve. I hope someone can help me.
I have a list of values in one column (A:A), that can have blank cells in the middle of the range and also repeat values, and I need to compare them with a second list of values of another column (B:B) and extract a unique list of the missing values (unique values that are in column A but not in column B):
<tbody>
</tbody>
Kind regards,
Thanks in advanced
I need some help with a problem that I am trying to solve. I hope someone can help me.
I have a list of values in one column (A:A), that can have blank cells in the middle of the range and also repeat values, and I need to compare them with a second list of values of another column (B:B) and extract a unique list of the missing values (unique values that are in column A but not in column B):
BD1 | BD2 | Missing in BD2 |
001-001-001 | 001-001-003 | 001-001-001 |
001-001-001 | 001-001-004 | 001-001-002 |
001-001-002 | ||
001-001-003 | ||
001-001-004 |
<tbody>
</tbody>
Kind regards,
Thanks in advanced