Issue
I would like to know how can I extract 1 list (column c) that consist of values that appear on both columns (A & B)?
Column A Column B Column C (e.g. answer)
202 203 203
203 204 204
204 206
205 207
Solution
Suppose data started from row A2:B50 then in C2 use this formula :
C2=IF(ISERROR(MATCH(A2,$B$2:$B$50,0)),"",A2)
and drag it down ......
Note that
Thanks to
mubashir aziz for this tip on the forum.