Excel: Find Matching Values in 2 Columns. [Duplicate]
This Question Already Has Answers Here: Find and Keep Matches from 2 Columns in Excel (2 Answers) Closed 8 Year's Ago. I Have a Spreadsheet with 2 Columns...
![Excel: Find Matching Values in 2 Columns. [Duplicate]](https://www.alledaags.nl/uploads/excel-find-matching-values-in-2-columns_1200.jpg)
I have a spreadsheet with 2 columns. These columns have telephone numbers in them. I need a list of where the same telephone numbers exists in both columns. These need to be listed in column C as the matching telephone number.
Excel 2010.
Regards
Look at the following screenshot, There is column A (A1:A15) and column C (C1:C13) which contain some duplicate names.
By using a formula, we can compare two columns and display the duplicate values. Please do with the following steps:
- In cell B1, input this formula: “=IF(ISERROR(MATCH(A1,$C$1:$C$13,0)),"",A1)”.
A1 is the column which you want to be compared.
$C$1:$C$13 is the range that you want to be compared with.
You can change the variables for what you are using.
Press the Enter key. Select cell B1, and then drag the fill handle over cell B15.
And all of the duplicate names will be displayed in column B. See screenshot:
just googled this
it does what you asked, takes duplicating values from 2 columns and puts them in a 3rd
Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.
