![excel find duplicate values in two lists excel find duplicate values in two lists](https://www.office-addins.com/_img/combine-excel-cell/merge-cells-wizard.png)
This assigns a unique name to your range of cells, which lets you refer to all these cells using a single name.Īssign a unique name to your second list by first selecting all rows of your list. Then, in the top-left corner, click the text box, type FirstList, and press Enter.
![excel find duplicate values in two lists excel find duplicate values in two lists](https://usermanual.wiki/Document/SQLWorkbenchManual.1388874451-User-Guide-Page-1.png)
EXCEL FIND DUPLICATE VALUES IN TWO LISTS HOW TO
RELATED: How to Use Conditional Formatting to Find Duplicate Data in Excelįirst, in your spreadsheet, select all rows of your first list. If you’d only like to highlight missing items in a specific list, then use a formula with conditional formatting as explained below. The above method highlights items in both your lists. The Formula Way: Use Conditional Formatting to Compare Lists For example, in your first list, you will have those items highlighted that are missing from the second list, and so on.Īnd that’s it. Then apply your changes to your lists by clicking “OK.”Įxcel will highlight the missing items in your lists. Tested and working: Option Explicit Sub finddups () ' Create and set variable for referencing workbook Dim wb As Workbook Set wb ThisWorkbook ' Create and set variable for referencing worksheet Dim ws As Worksheet Set ws wb.Worksheets ('Data') ' Find current last rows ' For this example, the data is in column A and the duplicates are in.
![excel find duplicate values in two lists excel find duplicate values in two lists](http://www.wikihow.com/images/0/0f/Find-Duplicates-in-Excel-Step-21.jpg)
To specify your own formatting, choose “Custom Format” from the menu. In the “Duplicate Values” box, click “Duplicate” and choose “Unique.” Click the second drop-down menu and choose how you would like to highlight the missing items.