Excel - Extract a list from 2 columns


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


Suppose data started from row A2:B50 then in C2 use this formula :


and drag it down ......

Note that

Thanks to mubashir aziz for this tip on the forum.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Excel - Extract a list from 2 columns », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).