Thank you for your help with this. I would like to add one twist. Is there
a way to limit the number to 500? The tickets come in booklets of 500 and I
do not need the formula to go higher than this.

Thanks again.

"Toppers" wrote:

Assuming you are happy with Gary's solution, try this modified version which
gives range of missing tickets i.e. 15-16 in your example in row 3:

=IF(A2=B1+1,"", B1+1 & "-" & A2-1)

"mmock" wrote:

You are correct......thank you again, I would have another ticket missing!!

"Toppers" wrote:

Shouldn't that be 11 tickets sold (numbers to 1 to 11 inclusive)?

"mmock" wrote:

Maybe to clarify more. On same days I will use or sell more than one ticket.
Line B1 - A1 = C1 (or 10 tickets sold). Is the +1 used only for when it is
1 above the previous number?
Thanks,
Mark


"mmock" wrote:

Prior to sending this post, I have read many posts and have not quite found
the answer I am looking for. I hope someone can help me with a formula.

I need to track tickets used. More importantly, I need to know if a ticket
in a sequence is missing. I will be tracking start & stop numbers and
tickets used. I'm looking for an indicator of some sort to tell me when a
ticket is missing or out of sequence.
Example

A1=1 B1=11 C1=10
A2=12 B2=14 C2=2
A3=17 B3=20 C3=3 (FLAG the 2 missing tickets 15 & 16)

Any assistance would be apprciated.
thanks,
Mark