How to Find Missing Numbers in a Sequence Using Microsoft Excel
- George Apostolov
- 05 Sep 2025
Guide
Inside your Microsoft Excel worksheet, select the cell where you wish to run the first formula and then type an 'Equals' (=) sign.
After that, input 'Sequence' and select it from the suggested results.
Add the Max function next. Simply type 'Max' and then choose it from the suggested results.
Subsequently, select the cell range that contains the series of numbers with missing values and then end the formula with two closing parentheses.
Click anywhere around the worksheet to run the first formula and process the result.
Following that, select another cell for the second formula and then type an 'Equals' (=) sign.
Input 'Unique' and then choose it from the suggested results.
Next, select the cell range containing the incomplete numeric series, as well as the result of the Sequence formula earlier.
Add a 'Comma' (,) and then choose 'False'.
Subsequently, select 'True' and then end the formula with a closing parenthesis. Tap anywhere around the worksheet to finally run the formula and process the result.
After completing these steps, the missing numbers from the selected numeric sequence will be identified instantly.
Create your first interactive demo in minutes
No credit card required • Start building today


