| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
indicate a missing number in a sequence
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
| Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
| A new sequence number in file everytime it is opened | Excel Worksheet Functions | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| Continuing Number Sequence | Excel Discussion (Misc queries) | |||
Threaded Mode
