Generate a list of missing invoice numbers


In a range of cells, assume there is a list of invoices raised during a certain period.  Since adequate care was not taken to number the invoices sequentially, there are missing invoice numbers in the Excel range.  So, it is possible that after raising invoice number 501, 502 and 503 the next invoice raised was 507.

Given the following:

1. Starting and ending invoice number (two numbers) from the invoice book; and
2. List of actual invoice numbers raised during a certain period (as elaborated above)

one may want to generate a list of missing invoices.

You may refer to two solutions in this workbook.

Leave a Comment Cancel reply

Your email address will not be published.


  • Dear Sir, your formula is awesome!
    I have one question. My condition says “false” while yours says “true”. any idea why? The formula seems to work just fine, but I don’t understand why that field is different.

    Can you help?

    • Thank you. I am glad you liked it. I am assuming that you are referring to the result in cell D3 of the Method2 worksheet. The TRUE/FALSE there does not matter. It just so happens that the first invoice number in the master invoice list is not available in the Invoice Number used list. The TRUE/FALSE result will not have any bearing on the end result.