Apologies if this has been asked before.

Suppose we have 2 columns of data, without loss of generality A and B. I would like to be able to produce a column C which contains entries that appear in columns A and B - in other words the entries of C are found in a cell An in column A and a cell Bm in column B where obviously m,n are integers.

If it helps, entries don't repeat in a column.

Simple example: Where A contains the entries 3, 7, 1, 4, 5 and B contains the entries 9, 1, 4, 5, 2 then C should contain 1, 4, 5 (order of entries in column C doesn't matter for my purpose)

in theHow to Ask. – CharlieRB Jun 2 '16 at 16:04help center