Microsoft Excel: How to Find Missing Numbers in a Sequence. Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate ...

Excel's SEQUENCE function lets you create a list of numbers in a sequence in an instant. It also allows you to define the shape, number of values, and steps between each number in the sequence ...

This is because SEQUENCE is a dynamic array function that produces a spilled array, and Excel tables aren't compatible with results generated in this way.