How to Find Missing Numbers in a Sequence Using Microsoft Excel

Quick summary

This tutorial shows how to find missing numbers in a sequence in Microsoft Excel by combining the SEQUENCE, MAX, and UNIQUE functions into two formulas. Once both formulas are entered correctly, Excel instantly outputs all values absent from the numeric series.

Steps

1. In your Microsoft Excel worksheet, select the cell where you want to enter the first formula, then type an equals sign (=).
2. Type SEQUENCE and select it from the autocomplete suggestions.
3. Add the MAX function by typing Max and selecting it from the suggested results.
4. Select the cell range that contains your numeric series with missing values, then close the formula with two closing parentheses.
5. Click anywhere on the worksheet to run the first formula and display the result.
6. Select a new cell for the second formula and type an equals sign (=).
7. Type UNIQUE and select it from the autocomplete suggestions.
8. Select the cell range containing the incomplete numeric series as well as the result of the SEQUENCE formula.
9. Add a comma (,) and then choose False.
10. Select True, then close the formula with a closing parenthesis and click anywhere on the worksheet to run it.
11. Excel will now instantly identify all missing numbers from the selected numeric sequence.