How do I find what's missing from a list in Excel?

Instead of using VLOOKUP or COUNTIF formulas in Excel, paste your two columns into this tool. List A gets your reference column, List B gets your actual column. Missing items are shown instantly in the 'Only in A' section — no formulas required.

Can this find missing emails or IDs from a list?

Yes. Paste your expected email or ID list into List A and your actual list into List B. The tool shows exactly which emails or IDs are missing from List B.

What if my lists have typos or slight variations?

Enable fuzzy matching in the options panel. The tool will catch near-matches using Levenshtein distance, so 'jon' matches 'john' and 'smithe' matches 'smith'.

Is this tool free and private?

Yes, completely free. All comparison happens locally in your browser — no data is sent to any server, so it is safe to use with confidential data like customer IDs, employee names, or financial records.

Find Missing Items Between Two Lists — Instantly

Paste your reference list and your actual list. The tool immediately shows which items are missing from each — no Excel formulas, no sign-up, no upload.

Find Missing Items Free → See a Live Example

List A — Expected invoices 5 items

List B — Received invoices 3 items

Edit either list and click Find Missing Items

Live preview — one-time comparison only. Open the full tool for export, fuzzy match, dedup, and save history.

How to Find Missing Items Between Two Lists

The quick answer:

Put your reference list (what you expect) in List A, and your actual list (what you have) in List B. The "Missing from B" result shows everything that's absent from List B.

This replaces the common Excel approach of using VLOOKUP, COUNTIF, or MATCH formulas to find missing values between two columns. Paste and done — no formula writing required.

Real-World Examples

Missing invoice numbers: List A = all invoices that should have been paid this month. List B = invoices actually received. "Missing from B" = missing invoices.

Missing survey respondents: List A = all participants who should have completed a survey. List B = who actually responded. "Missing from B" = people who haven't responded yet.

Missing product SKUs: List A = full product catalogue. List B = products in your current inventory system. "Missing from B" = items not yet added to inventory.

Missing email addresses: List A = all registered users. List B = users in your email marketing platform. "Missing from B" = users not yet added to your mailing list.

Missing hostnames: List A = servers that should be running. List B = servers detected in a recent scan. "Missing from B" = servers that didn't respond to the scan.

Tips for Finding Missing Items

Case sensitivity: By default the comparison is case-insensitive, so "Apple" and "apple" are treated as the same item. Turn on case-sensitive mode if your data requires exact case matching.

Duplicates: Enable deduplication to remove repeated entries within each list before comparing — this avoids false positives from repeated values.

Typos and near-matches: Enable fuzzy matching to catch items that are almost identical. This is useful when data from different sources has slight spelling variations.

Export results: Once you've found the missing items, export the "Missing from B" section as a CSV file for further action.

Frequently Asked Questions

How do I find missing items between two lists?

Put your reference list (what you expect) in List A and your actual list in List B. The "Missing from B" section shows everything absent from List B.

How do I find missing values without Excel formulas?

Paste your two columns into this tool instead. No VLOOKUP, COUNTIF, or MATCH formulas needed — results are instant.

Can I find missing emails or IDs?

Yes. Paste your expected list into List A and your actual list into List B. Missing emails or IDs appear in the "Missing from B" result.

What about typos in my lists?

Enable fuzzy matching in the options panel. Near-matches (like "jon" for "john") are then treated as found rather than missing.

Is this free and private?

Yes — free, no sign-up, and 100% browser-based. No data is sent to any server.