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. Open your spreadsheet in ...

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.