Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate business check numbers that haven't been logged into a balance ...

Use Excel for web or the Excel for Microsoft 365 desktop app for the latest Excel features, including the newest dynamic array functions. The six functions in this article are available in versions of ...