software

Thank you again for helping me with the formula below. I hoping you can help
me with one more twist. I only need the formula to count to 500. There are
only 500 tickets in the booklet. If the count goes higher than 500 I do not
want it to count an out of sequence or just leave the cell blank. Does this
make sence?

Thank you for the assistance!
M.

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,quot;quot;, B1 1 amp; quot;-quot; amp; A2-1)

quot;mmockquot; wrote:

gt; You are correct......thank you again, I would have another ticket missing!!
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; Shouldn't that be 11 tickets sold (numbers to 1 to 11 inclusive)?
gt; gt;
gt; gt; quot;mmockquot; wrote:
gt; gt;
gt; gt; gt; Maybe to clarify more. On same days I will use or sell more than one ticket.
gt; gt; gt; Line B1 - A1 = C1 (or 10 tickets sold). Is the 1 used only for when it is
gt; gt; gt; 1 above the previous number?
gt; gt; gt; Thanks,
gt; gt; gt; Mark
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Prior to sending this post, I have read many posts and have not quite found
gt; gt; gt; gt; the answer I am looking for. I hope someone can help me with a formula.
gt; gt; gt; gt;
gt; gt; gt; gt; I need to track tickets used. More importantly, I need to know if a ticket
gt; gt; gt; gt; in a sequence is missing. I will be tracking start amp; stop numbers and
gt; gt; gt; gt; tickets used. I'm looking for an indicator of some sort to tell me when a
gt; gt; gt; gt; ticket is missing or out of sequence.
gt; gt; gt; gt; Example
gt; gt; gt; gt;
gt; gt; gt; gt; A1=1 B1=11 C1=10
gt; gt; gt; gt; A2=12 B2=14 C2=2
gt; gt; gt; gt; A3=17 B3=20 C3=3 (FLAG the 2 missing tickets 15 amp; 16)
gt; gt; gt; gt;
gt; gt; gt; gt; Any assistance would be apprciated.
gt; gt; gt; gt; thanks,
gt; gt; gt; gt; Mark
gt; gt; gt; gt;Try:

=IF(A2lt; 500,IF(A2=B1 1,quot;quot;, B1 1 amp; quot;-quot; amp; A2-1),quot;quot;)

Using this test data:
A B C
110
1120
21490
493500491-492
501510

Is this what you want?quot;mmockquot; wrote:

gt; Thank you again for helping me with the formula below. I hoping you can help
gt; me with one more twist. I only need the formula to count to 500. There are
gt; only 500 tickets in the booklet. If the count goes higher than 500 I do not
gt; want it to count an out of sequence or just leave the cell blank. Does this
gt; make sence?
gt;
gt; Thank you for the assistance!
gt; M.
gt;
gt;
gt;
gt;
gt; Assuming you are happy with Gary's solution, try this modified version which
gt; gives range of missing tickets i.e. 15-16 in your example in row 3:
gt;
gt; =IF(A2=B1 1,quot;quot;, B1 1 amp; quot;-quot; amp; A2-1)
gt;
gt; quot;mmockquot; wrote:
gt;
gt; gt; You are correct......thank you again, I would have another ticket missing!!
gt; gt;
gt; gt; quot;Toppersquot; wrote:
gt; gt;
gt; gt; gt; Shouldn't that be 11 tickets sold (numbers to 1 to 11 inclusive)?
gt; gt; gt;
gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Maybe to clarify more. On same days I will use or sell more than one ticket.
gt; gt; gt; gt; Line B1 - A1 = C1 (or 10 tickets sold). Is the 1 used only for when it is
gt; gt; gt; gt; 1 above the previous number?
gt; gt; gt; gt; Thanks,
gt; gt; gt; gt; Mark
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Prior to sending this post, I have read many posts and have not quite found
gt; gt; gt; gt; gt; the answer I am looking for. I hope someone can help me with a formula.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I need to track tickets used. More importantly, I need to know if a ticket
gt; gt; gt; gt; gt; in a sequence is missing. I will be tracking start amp; stop numbers and
gt; gt; gt; gt; gt; tickets used. I'm looking for an indicator of some sort to tell me when a
gt; gt; gt; gt; gt; ticket is missing or out of sequence.
gt; gt; gt; gt; gt; Example
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; A1=1 B1=11 C1=10
gt; gt; gt; gt; gt; A2=12 B2=14 C2=2
gt; gt; gt; gt; gt; A3=17 B3=20 C3=3 (FLAG the 2 missing tickets 15 amp; 16)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Any assistance would be apprciated.
gt; gt; gt; gt; gt; thanks,
gt; gt; gt; gt; gt; Mark
gt; gt; gt; gt; gt;
gt;

Thank you TOppers.....it worked great.
One more question...what it the purpose of the space after the lt; 500. Does
it matter if there is a space there???

Thank you again for your help!
m.quot;Toppersquot; wrote:

gt; Try:
gt;
gt; =IF(A2lt; 500,IF(A2=B1 1,quot;quot;, B1 1 amp; quot;-quot; amp; A2-1),quot;quot;)
gt;
gt; Using this test data:
gt; A B C
gt; 110
gt; 1120
gt; 21490
gt; 493500491-492
gt; 501510
gt;
gt; Is this what you want?
gt;
gt;
gt; quot;mmockquot; wrote:
gt;
gt; gt; Thank you again for helping me with the formula below. I hoping you can help
gt; gt; me with one more twist. I only need the formula to count to 500. There are
gt; gt; only 500 tickets in the booklet. If the count goes higher than 500 I do not
gt; gt; want it to count an out of sequence or just leave the cell blank. Does this
gt; gt; make sence?
gt; gt;
gt; gt; Thank you for the assistance!
gt; gt; M.
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; Assuming you are happy with Gary's solution, try this modified version which
gt; gt; gives range of missing tickets i.e. 15-16 in your example in row 3:
gt; gt;
gt; gt; =IF(A2=B1 1,quot;quot;, B1 1 amp; quot;-quot; amp; A2-1)
gt; gt;
gt; gt; quot;mmockquot; wrote:
gt; gt;
gt; gt; gt; You are correct......thank you again, I would have another ticket missing!!
gt; gt; gt;
gt; gt; gt; quot;Toppersquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Shouldn't that be 11 tickets sold (numbers to 1 to 11 inclusive)?
gt; gt; gt; gt;
gt; gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Maybe to clarify more. On same days I will use or sell more than one ticket.
gt; gt; gt; gt; gt; Line B1 - A1 = C1 (or 10 tickets sold). Is the 1 used only for when it is
gt; gt; gt; gt; gt; 1 above the previous number?
gt; gt; gt; gt; gt; Thanks,
gt; gt; gt; gt; gt; Mark
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Prior to sending this post, I have read many posts and have not quite found
gt; gt; gt; gt; gt; gt; the answer I am looking for. I hope someone can help me with a formula.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I need to track tickets used. More importantly, I need to know if a ticket
gt; gt; gt; gt; gt; gt; in a sequence is missing. I will be tracking start amp; stop numbers and
gt; gt; gt; gt; gt; gt; tickets used. I'm looking for an indicator of some sort to tell me when a
gt; gt; gt; gt; gt; gt; ticket is missing or out of sequence.
gt; gt; gt; gt; gt; gt; Example
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; A1=1 B1=11 C1=10
gt; gt; gt; gt; gt; gt; A2=12 B2=14 C2=2
gt; gt; gt; gt; gt; gt; A3=17 B3=20 C3=3 (FLAG the 2 missing tickets 15 amp; 16)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Any assistance would be apprciated.
gt; gt; gt; gt; gt; gt; thanks,
gt; gt; gt; gt; gt; gt; Mark
gt; gt; gt; gt; gt; gt;
gt; gt;

Not needed ...lt;500 will work.

quot;mmockquot; wrote:

gt; Thank you TOppers.....it worked great.
gt; One more question...what it the purpose of the space after the lt; 500. Does
gt; it matter if there is a space there???
gt;
gt; Thank you again for your help!
gt; m.
gt;
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; Try:
gt; gt;
gt; gt; =IF(A2lt; 500,IF(A2=B1 1,quot;quot;, B1 1 amp; quot;-quot; amp; A2-1),quot;quot;)
gt; gt;
gt; gt; Using this test data:
gt; gt; A B C
gt; gt; 110
gt; gt; 1120
gt; gt; 21490
gt; gt; 493500491-492
gt; gt; 501510
gt; gt;
gt; gt; Is this what you want?
gt; gt;
gt; gt;
gt; gt; quot;mmockquot; wrote:
gt; gt;
gt; gt; gt; Thank you again for helping me with the formula below. I hoping you can help
gt; gt; gt; me with one more twist. I only need the formula to count to 500. There are
gt; gt; gt; only 500 tickets in the booklet. If the count goes higher than 500 I do not
gt; gt; gt; want it to count an out of sequence or just leave the cell blank. Does this
gt; gt; gt; make sence?
gt; gt; gt;
gt; gt; gt; Thank you for the assistance!
gt; gt; gt; M.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Assuming you are happy with Gary's solution, try this modified version which
gt; gt; gt; gives range of missing tickets i.e. 15-16 in your example in row 3:
gt; gt; gt;
gt; gt; gt; =IF(A2=B1 1,quot;quot;, B1 1 amp; quot;-quot; amp; A2-1)
gt; gt; gt;
gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; You are correct......thank you again, I would have another ticket missing!!
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Toppersquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Shouldn't that be 11 tickets sold (numbers to 1 to 11 inclusive)?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Maybe to clarify more. On same days I will use or sell more than one ticket.
gt; gt; gt; gt; gt; gt; Line B1 - A1 = C1 (or 10 tickets sold). Is the 1 used only for when it is
gt; gt; gt; gt; gt; gt; 1 above the previous number?
gt; gt; gt; gt; gt; gt; Thanks,
gt; gt; gt; gt; gt; gt; Mark
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; Prior to sending this post, I have read many posts and have not quite found
gt; gt; gt; gt; gt; gt; gt; the answer I am looking for. I hope someone can help me with a formula.
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; I need to track tickets used. More importantly, I need to know if a ticket
gt; gt; gt; gt; gt; gt; gt; in a sequence is missing. I will be tracking start amp; stop numbers and
gt; gt; gt; gt; gt; gt; gt; tickets used. I'm looking for an indicator of some sort to tell me when a
gt; gt; gt; gt; gt; gt; gt; ticket is missing or out of sequence.
gt; gt; gt; gt; gt; gt; gt; Example
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; A1=1 B1=11 C1=10
gt; gt; gt; gt; gt; gt; gt; A2=12 B2=14 C2=2
gt; gt; gt; gt; gt; gt; gt; A3=17 B3=20 C3=3 (FLAG the 2 missing tickets 15 amp; 16)
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; Any assistance would be apprciated.
gt; gt; gt; gt; gt; gt; gt; thanks,
gt; gt; gt; gt; gt; gt; gt; Mark
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt;