Non Duplicate Values

Skip to first unread message

Akshay Monga

Sep 25, 2016, 2:48:04 AM9/25/16
to spreadsheet

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
1c                     1a
1d                     1b

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 ?
Reply all
Reply to author
0 new messages