It also allows you to define the shape, number of values, and steps between each number in the sequence, and you can use SEQUENCE in conjunction with other Excel functions.

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

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.