Hide

Filtering By Columns Of Numbers

You can download here the worksheet from this video to practice it by yourself!

When is it useful to filter by numbers?

Numerical filter is designed to handle values such as financials, ages, amounts, serial numbers, and all other data represented by numbers.

You can use it for example, with a list of bank accounts, to filter all accounts above a certain balance to figure out who your largest clients are, or filter below zero to see who owes the bank money.

In the same fashion you can filter your first 100 clients by serial number.

In a table with student details, you can display all of the students that are underaged, or those who qualify for honors or an AP class based on their grades.

Filtering prices between 2 values will let you search within a price window that you can afford.

Filtering by numerical values is useful for anyone who uses numbers in Excel and I am yet to meet a person who doesn’t. Use this tool and you’ll be able to add a lot of flexibility in displaying your information and will be able to do it in a focused and effective way.