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.

Text in a cell in Excel is called a text string. Excel provides a number of built-in functions enabling you to select and manipulate text strings in cells. The easiest way to identify or extract a ...