Excel - Extract a list from 2 columns

October 2016


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.

Related :

This document entitled « Excel - Extract a list from 2 columns » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.