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!
Solved! Go to Solution.