Menu
  1. Accueil
  2. How To
  3. Software
  4. Office Software
  5. Excel
Thanks
0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Extract a list from 2 columns

Latest update on by aakai1056 .



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.
Thanks
0
Thanks

A few words of thanks would be greatly appreciated.

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).

0 Comments