C
chris78
Hi,
I have two columns - A and B - each filled with values. Some of the
values in column B also exist in column A.
I need to create a column C in which the values from column B are
removed from column A (if they exist in column A, that is). For
example:
A | B | C
---------------
1 | 3 | 1
2 | 5 | 2
3 | 8 | 4
4 | 9 | 6
5 |
6 |
The point being that column C does NOT contain values that only exist
in column B, but rather contains the values from column A MINUS the
values that exist in both column A and B.
Does anyone have an idea for a function that could solve this?
Thanks in advance!
Kind regards,
Chris
------------------------------------------------
------------------------------------------------
I have two columns - A and B - each filled with values. Some of the
values in column B also exist in column A.
I need to create a column C in which the values from column B are
removed from column A (if they exist in column A, that is). For
example:
A | B | C
---------------
1 | 3 | 1
2 | 5 | 2
3 | 8 | 4
4 | 9 | 6
5 |
6 |
The point being that column C does NOT contain values that only exist
in column B, but rather contains the values from column A MINUS the
values that exist in both column A and B.
Does anyone have an idea for a function that could solve this?
Thanks in advance!
Kind regards,
Chris
------------------------------------------------
------------------------------------------------