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 ...

If argument d is 0, the result will repeat the same number, as you're telling Excel not to add any increments between each ...