AnsweredAssumed Answered

Finding missing numbers in a sequence

Question asked by twalz on Feb 29, 2012
Latest reply on Jan 19, 2018 by philmodjunk

Several times a month I import an Excel file. One of the cells is a serial number for a particular item. It is sequential from 00001 to 01200 every month, resetting at the beginning of each month. For example, right now it runs from 00001 to about 01050 and should continue building with each import through the end of the month until it reaches about 01200. Next month it starts over at 00001.

 

On occasion, the source sending me the Excel file skips a number in the sequence. For example, it might be 00001, 00002, 00003, 00005, skipping 00004. Or occasionally the import does go completely right, and bunch of the numbers are left out. A client using my FileMaker solution wants an easy way to find and list those missing numbers.

 

Is there a way to script this, serching through a field with sequential numbers and identifying those missing numbers?

Outcomes