The solution lies with using Excel's array feature to traverse a data list automatically and extract missing sequential numbers, even if the number list is out of order.

If you need to find the maximum or minimum number of items in a column or list, position your cursor somewhere outside the matrix and enter this function for Maximum: =MAX (E33:E37) or this for ...