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

Creating a list of consecutive numbers is one of the easiest ways to create unique IDs for product lists, transaction IDs or event numbers. Of course, manually typing the next consecutive integer is ...

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values. The fill handle in Microsoft Excel accommodates ...

Spreadsheet software is supposed to make life easier, not torture you with endless hours of data entry. Before you curse Excel and wish that you were working back in the good old days of paper ledgers ...