Home > Big Data Analytics > Excel - Extract a list from 2 columns
Big Data Analytics

Excel - Extract a list from 2 columns

On November 17,2022 by

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.

Leave a Reply

Your email address will not be published. Required fields are marked *