ReconNimble tool

Find records missing from one spreadsheet

Use this tool when management asks what is billed but not in your master, what is active but missing from a dump, or what serials are absent from a received list.

Start reconciliation View all tools

Use cases

Missing employees in email dump
Vendor-billed assets missing in internal master
Serials missing from received list

How it works

Upload both datasets
Pick Missing from A in B or Missing from B in A
Select the comparison key
Export the action sheet

Formula logic

ReconNimble explains the matching logic in plain English using equivalents such as VLOOKUP, XLOOKUP, IFERROR, COUNTIF, FILTER, UNIQUE, TRIM and CLEAN.

Upload files

FAQ

Questions about Find Missing Records Online

What Excel logic is similar?

This is similar to VLOOKUP or XLOOKUP wrapped with IFERROR.

Can I export missing records?

Yes. Delivery 2 already includes CSV, XLSX and PDF summary export options.

Related tools

Continue with another reconciliation utility or upload your files directly.

Find missing records Find duplicates VLOOKUP alternative Start now