Indicate missing number in a sequence (Part II)

M

mmock

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)
 
T

Toppers

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?
 
M

mmock

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.
 
T

Toppers

Not needed ...<500 will work.

mmock said:
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.
 

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

Top