In a spreadsheet, I have a row with 100s of values. Lets says column A.
Now in column B, I have more values, some of which are similar to values in Column A.
I want to have values from A which are not similar to values in B.
Example as below
Column A Column B Column C
1a 2a 1c
1b 2b 1d
The column C does not show values which are present both in A an B.
What should I do / formula to use to get values as such ?