Non Duplicate Values

12 views
Skip to first unread message

Akshay Monga

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

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
Forward
0 new messages