Display missing numbers from a sequence

L

lrxc

I am importing invoice data from an accounting system to display all the
sales activity from the day.
We normally have invoices that are deleted thoughout the day. Is there a
formula that I could use that will display all the missing invoices in the
sequence?
 
O

Otto Moehrbach

What is the format of your invoice numbers? Are the invoice numbers sorted
increasing? What cell holds the first invoice number? Is the last invoice
number the last entry in that column? Where do you want this list of
missing invoice numbers placed? A formula will not do what you want, but
VBA (programming) will. Post back with this information and I'll write you
a macro. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Display Missing invoice numbers from a sequence. 2
Help creating a search form in Access XP 0
Creating a Chart on form from selected data in query. 0
Create a chart from a table in word thats dynamic 0
sequencing numbers 5
Selecting Latest Invoice from a Group of Invoices 1

Top