Baro Calculators.
Home/Compare Two Lists
Text & lists

Compare Two Lists: Common & Missing Entries

Find common entries and entries missing from either list.

Inputs are processed in your browser. Save on this device only when you choose to.

RESULT

Enter values and show the result.

How results are produced

Each list is deduplicated before comparison. Common entries retain their first spelling from list A. Order is preserved.

Worked example

For A = 00123, 00456 and B = 00456, 00789, the common entry is 00456. A-only is 00123 and B-only is 00789.

How to use

  1. Enter one item per line in both lists.
  2. Choose comparison rules.
  3. Copy each result or save a spreadsheet-friendly file.
PUT IT TO USE

Find missing identifiers between two Excel columns

Copy one spreadsheet column into each input. This compares exact entries rather than reading a whole workbook.

  1. Paste 00123 and 00456 into List A on separate lines.
  2. Paste 00456 and 00789 into List B.
  3. Show the result. Common is 00456. A-only is 00123 and B-only is 00789.
  4. Copy the group you need or export the result as Excel CSV.
Find missing identifiers between two Excel columns: Baro Calculators example screen with sample inputs and results
Illustrative example screen using sample data. There is no fuzzy matching. Choose the letter-case and surrounding-whitespace rules that fit your lists.

Continue your task

Remove Duplicate Lines & Keep List Order · Text Cleaner

Try these values in the tool

Frequently asked questions

Does this require an account?

No. Processing takes place in your browser. Saving inputs on this device is optional.

How can I share a result?

Copy, download or print it. Email opens your own mail composer; you send the message yourself.

Related tools

Word & Character CounterCheck word counts, character limits and separate writing sections.Text CleanerClean pasted text and compare the original with the result.Duplicate List RemoverReview duplicate counts and keep the first occurrence in order.