Picture month-end, your accountant asking for invoice 1004, and you realising you have no idea whether it was never raised, was deleted, or is sitting in someone else’s drawer — that’s the moment you need to use a missing numbers finder before a small hole turns into a row about unbilled work.
One number per line, or separate them with commas or spaces. Leave the start and end boxes blank to check from your smallest number to your largest.
Missing numbers - paste-ready list
Gap ranges
| Gap range | From | To | Numbers missing |
|---|
Invalid lines
| Line | Entry |
|---|
How the missing numbers finder works
Paste the whole list into the box above — one number per line, or separated by commas or spaces. The tool reads each line, pulls out the numbers, and sorts them into order for you.
It then walks from your smallest number to your largest, one step at a time, and notes every number it never sees. If you type an expected start and end, it walks that range instead, so numbers missing from the ends show up too.
You get three things back: a paste-ready list of every missing number, the gaps grouped into ranges like 1007–1008, and counts for how many numbers you checked, how many are missing, and how many lines it could not read.
Find missing numbers in a list, without a formula
Paste the list, one number per line, and the finder returns the gaps grouped into ranges, with a count. No formula is needed, and the list does not need sorting first.
What counts as a gap
A gap is any whole number the tool expects to see but doesn’t. If your invoices run from 1001 to 1010, it expects 1001, 1002, 1003, and so on — nothing skipped, nothing extra.
That sounds strict, and it is meant to be. A run of numbers that should be consecutive leaves no room for a quiet skip, and a quiet skip is exactly how unbilled work and lost records slip past you.
It does not count a number that sits outside your range. If your list starts at 1001, the tool won’t flag 1000 as missing, because you never told it to look there. Set a start and end if you want the edges checked too.
A gap can be one number on its own, or a run of several in a row. Either way, the tool groups neighbours together, so you see two gaps to chase up instead of a long, flat list of single numbers.
Worked example: gaps in invoice numbers 1001–1010
Say your invoice list reads 1001, 1002, 1003, 1005, 1006, 1009, 1010. At a glance it looks fine — the numbers climb, nothing looks out of place, and your eye slides straight past the holes.
Run the check and you get three missing numbers: 1004 on its own, and 1007–1008 as one range. That’s two gaps, three numbers, and a very short list to chase up.
Click Load example above and run it yourself — you’ll see exactly that result: 7 numbers checked, 3 missing, 0 invalid lines, and the ranges 1004 and 1007–1008.
Try it with your own start and end too. Type 1001 in the start box and 1010 in the end box and you’ll get the same answer, because the tool was already checking from your smallest to your largest number.
What to do about a gap once you find it
Don’t just renumber the next invoice and move on. A gap is a question, not a tidy-up job, and the answer matters more than the number.
First, check whether the missing number was ever used. Search your invoicing app, your sent email, and any paper pads or duplicate books — the invoice may exist, just not where you expected it.
If you find it, note where it turned up, so the same search takes seconds next time. If you can’t find it, ask the person who should have raised it, while the job is still fresh in their mind.
If the number was voided or cancelled, keep a short note — “1004 voided, client changed the scope” — so the next audit doesn’t turn the same gap into a fresh worry.
And if you find work that was never billed, raise the invoice now, while the client still remembers the job. A gap found this month is a fix; the same gap found a year later is a dispute.
Invalid and duplicate entries
Real exports are messy. A line that reads “INV-1005” or “tbc” can’t be checked as a number, so the tool flags it as invalid instead of guessing what you meant.
Fix those lines in your source list and run the check again. A single stray character can hide a real gap, and it’s far better to clean the list first than to trust a result built on lines the tool couldn’t read.
Duplicates get a different treatment. If 1003 appears twice, it still counts as present, so it’s never listed as missing. The tool counts duplicates separately, so you can see a double entry without it muddying the gap list — handy if the same invoice was raised twice by mistake.
Frequently asked questions
Does the list need sorting first?
No. Paste your numbers in any order. The tool sorts them and removes duplicates before it walks through the sequence, so a shuffled export gives the same result as a tidy one.
What if my numbers start above 1?
Nothing special happens. The check runs from the smallest number in your list, so invoice numbers that start at 1001 or ticket numbers that start at 5000 work just as well as a list that starts at 1.
Can it check a custom start-to-end range?
Yes. Type the first and last numbers you expect in the start and end boxes, for example 1001 to 1010, and the tool checks that whole range, including numbers at the ends that never appear in your list.
Are duplicates treated as missing?
No. A number that appears twice still counts as present, so it is never listed as missing. Duplicates are counted separately, so you can spot a double entry without it muddying the gap list.
How do I find missing numbers in a list in Excel?
Paste the list here instead of writing a formula, and the finder returns the missing numbers grouped into ranges. You can download the result as a CSV and paste the gaps back into your sheet.
Can it find missing invoice numbers with a prefix?
Yes. Numbers with a shared prefix, like INV-1001, are handled, and the gaps are reported per group with labels, so each prefix gets its own missing-number list.
Related list tools
If you work with lists a lot, these help too. If your dates should run day by day, use the Missing Dates in a List Finder to spot the days that never made it into your list.
When the dates themselves are a mess, the Messy Date Cleaner tidies them into one format first, and the Bulk Days-Until / Days-Since List works through a whole list of dates at once.