GapsInSequence ( listOfValues )
Returns a list of gaps found in an incrementing sequence.
Be the first to rate this function Log in to vote
Michael Horak - Show more from this author
*COMMENT Visual Realisation
with the following listOfValues:
Invoice 9 - Invoice 10
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Returns a list of gaps (missing values) found in an incrementing sequence. Each gap is listed as an individual value or as a range.
A companion function to CollapseList() https://www.briandunning.com/cf/734
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.