Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to compare two lists of email addresses in Excel worksheet?

Supposing, there are two lists of Email addresses in a worksheet, now, you would like to find out the Email addresses that exist both in two Email columns. If an Email address in column B which also exists in column A, the text "Match Found" will be displayed next to the corresponding email address in column C as following screenshot shown. This article, I will talk about some useful methods to solve this job in Excel.

doc compare two lists 1

Compare two lists of Email addresses and find the same ones with formula

Compare two lists of Email addresses and select or highlight the same ones with Kutools for Excel


Compare two lists of Email addresses and find the same ones with formula

The following formula can help you find out the Email addresses which both in Column A and Column B, please do as this:

1. Enter this formula in a blank cell where will output the result: =IF(COUNTIF($A$2:$A$10,B2)>0, "Match Found",""), and then drag the fill handle down to the cells to get the results.

2. If the Email address in column B exists in column A, a Match Found text is displayed next to the corresponding email address in column C, see screenshot:

doc compare two lists 2


Compare two lists of Email addresses and select or highlight the same ones with Kutools for Excel

If you have Kutools for Excel, with its Select Same & Different Cells feature, you can quickly select the same Email addresses which locate in both columns.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 60 days. 

After installing Kutools for Excel, please do as this:

1. Select the two columns that you want to compare and find the same Email addresses, and then click Kutools > Select > Select Same & Different Cells, see screenshot:

doc compare two lists 3

2. In the Select Same & Different Cells dialog box, please do the following operations:

(1.) Check My data has headers if there are headers in your selected data;

(2.) Then select Each row from the Based on section;

(3.) And then select Same values from the Find section;

(4.) At last, you can choose one background or font color to highlight the selected cells as you need under the Processing of results section.

doc compare two lists 4

3. And then click Ok button, the same Email addresses which exist in two lists have been selected and highlighted in Column A, see screenshot:

doc compare two lists 5

Click to Download Kutools for Excel and free trial Now!



Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.