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



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.

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.

More Features:
Excel Work Area View
Excel Work Area If you have many data in Excel sheet cells, and want to…
Excel Random Generator
Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…
Excel Remove All Macros
Remove All Macros From Excel Workbooks Delete Macros, User Forms, VBA modules, etc. from Excel…
Excel Hyperlinks Sheet Names
Convert All Your Worksheets into Hyperlinks in One Worksheet Extract all sheets names as hyperlinks…
Excel Compare Sheets – Advanced Excel Sheet Comparison Tool
Why Compare Excel Sheets? When working with finance reports, inventory audits, or versioned data sets,…
Excel Count Chars
Count Chars In Excel Count chars in a cell or in a selected range of…