Indicate missing number in a sequence (Part II)

[Guest]

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,"", B1+1 & "-" & A2-1)

 

[Guest]

Try:

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

Using this test data:
A B C
1 10
11 20
21 490
493 500 491-492
501 510

Is this what you want?

 

[Guest]

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

Thank you again for your help!
m.

 

[Guest]

Not needed ...<500 will work.

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

Thank you again for your help!
m.