There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.

But you might wonder how to limit the number of columns in a filtered result set. You can’t using a simple Excel filter, because the feature filters the source data in place.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.