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

There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions. Image: ...

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

Have you ever opened your spreadsheet only to find your carefully typed numbers missing their decimals, or worse, transformed into something like 2.95E+07? If yes, you’ve seen the downside of relying ...

Lists of phone numbers are very common with Microsoft Excel editors. In the case of landline and foreign phone numbers, adding the country code is important, or the caller will never be able to dial ...

Keeping data on the number of leap years in a list is important for companies, government offices, and event organizers. If you need to check for the number of leap years between two dates in Excel, ...

Everyone on the planet has heard of Microsoft Excel. It’s the world’s analytical infrastructure. Estimates are that 1,500,000,000 people use Excel. Users love it at least twice a day and typically ...

If you need to calculate dates in your spreadsheets, Excel uses its own unique system, which it calls Serial Numbers. Every date (month, day, year) and time (hour, minute, and second) has an ...