Get difference between two columns

[ssphv]

Hello,

I have a sample data as below. My requirement is I would like to find if all records in column1 exist in column2. Generate a new column next to column1 and show result as yes if it exists in column2 else no if it does not exist in column2. How can I achieve this. 

Column1	Column2
25	70
31	69
44	55
58	2
66	31
71	13
98	44
	29
	25
	10

Thank you in advance!

[JoBen · Accepted solution]

Hi @ssphv, are you looking for something like this?