Excel - Extract a list from 2 columns
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.
Related
- Excel - Extract a list from 2 columns
- Excel data validation list show 2 columns - How-To - Excel
- Excel - Comparing 2 columns and removing duplicates - How-To - Excel
- Compare the words in 2 columns in Excel ✓ - Forum - Excel
- A variation on the compare 2 columns in Excel ✓ - Forum - Excel
- Find Value Between 2 column Range Excel Macro ✓ - Forum - Excel
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).
Subscribe To Our Newsletter!
