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

Usually, spreadsheets are used to store actual business data - not randomized information. But spreadsheets can still be useful to generate random numbers in Excel. Random data can be used as input to ...

This is the easiest method to reverse a list in Excel. You just have to create a new column containing the numbers in ascending order and use this column to reverse the list. Let’s see how to do that.

Some of my reports list Social Security numbers. Since the reports are often viewed by others, I need a convenient but secure way to hide those numbers—such as making only the last four digits visible ...

Both the Currency and Accounting number formats in Excel are used to display monetary values, including the symbol for the chosen currency. However, in this article, I'll explain their subtle ...