Compare Lists in Excel
If you ever want to compare lists by looking up for values that exist in 1st list and matches with values in the 2nd list or even looking for values that exist in the 1st list and not exist in the 2nd list and then color them, then this feature is for you. Dose for Excel’s Compare Lists utility can easily look at your lists and compare them with one click on huge Excel sheets.
- Find values in 1st list that exist in the 2nd list
- Find values in 1st list that do not exist in the 2nd list
Click DOSE » Compare Lists
![Excel Compare Lists](https://zbrainsoft.com/wp-content/uploads/2023/06/excel-compare-lists.png)
![Excel Compare Lists](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Compare Lists](https://zbrainsoft.com/wp-content/uploads/2023/06/excel-compare-lists-pane.png)
Find values in 1st list that exist in the 2nd list
- Select range of List 1 where the lookup values exist.
- Select range of List 2 where to look in.
- Condition: select “In”
- Then click Apply. In below example, all values in list 1 and exist in list 2 have been colored. You will see the result as shown in the below screenshot.
![Excel Compare Lists](https://zbrainsoft.com/wp-content/uploads/2023/06/excel-compare-lists-example-1.png)
Find values in 1st list that do not exist in the 2nd list
- Select range of List 1 where the lookup values exist.
- Select range of List 2 where to look in.
- Condition: select “Not In”.
- Then click Apply. In below example, all values in list 1 that do not exist in list 2 have been colored. You will see the result as shown in the below screenshot.
![Excel Compare Lists](https://zbrainsoft.com/wp-content/uploads/2023/06/excel-compare-lists-example-2-1.png)
More Features:
How To Convert Numbers To Words In Excel
Convert numbers to words in Excel Converting numerical values into words in Excel holds significant…
Excel Delete Rows
Excel Highlight Or Delete Any Type Of Rows Highlight or delete items that are identical,…
Excel Import Files Names
Import Files Names From Your Folder Into Excel Import your directory or folder files names…
Excel Insert Empty
Insert Empty Rows Or Columns At Certain Interval In Excel If you ever want to…
Excel Reading Layout View
Excel Reading Layout If you have a lot of data at your Excel sheet, then…
Excel How to Remove Only Text Or Only Numbers
Remove text or numbers or symbols from cells in Excel You can remove only text…