Answer the question
In order to leave comments, you need to log in
How to remove values from column B, which contains column A?
Good afternoon. There are two columns. There are only numerical values.
I need only those values in column B that are not in column A.
Or in other words: The unique value must be displayed in column C.
If B1 = not equal to any of the values of column A = Put this value in column C.
Please tell me how do it right?
Answer the question
In order to leave comments, you need to log in
in C2 we write =IFERROR(MATCH(B2;A:A;0);"")
Next, we extend the formula
with a filter, leave all the values that are not "" and these will be duplicates of column B that are in column A
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question