Excel filters: How to use number, text and date filters to extract only the data you need

    Excel spreadsheet databases work as a result of customers can filter the information inside these workbooks. Filters are situations you specify in databases and spreadsheets to extract solely the exact, requested data. 

    For instance, in a Human Assets spreadsheet database, the IT director could wish to rent a candidate with a level in Laptop Science plus expertise utilizing HTML, Java, and C++ languages. The IT director makes use of filters primarily based on logical operators to extract all of the candidates with these credentials: equal to (Equals) levels in “Laptop Science” plus laptop languages equal to (Equals) “HTML, Java, and C++.” She could add extra situations, similar to candidates equal to (Equals) “CS Software program Developer,” however not equal to (Does Not Equal) “CS Engineer,” to reduce the listing. This selective course of can go on and on till the variety of candidates is pared all the way down to an inexpensive quantity.

    Be aware that the information extraction relies on the sector columns in your database. You can’t extract candidates equal to “speaks Spanish” if the database doesn’t include a area for languages. Due to this fact, it is critically vital that you simply create area columns to gather all the knowledge that you simply plan to extract or filter by later.

    On this how-to, we’ll present you how you can apply Date, Quantity, and Textual content filters to your spreadsheet. To make it simpler so that you can apply the filtering duties we’re about to explain, we have created a downloadable Excel workbook with all the information we use on this article. Simply click on the arrow or hyperlink beneath to start out the obtain.


    It is a workbook with a number of spreadsheets whose content material can be utilized to apply Excel duties in relational databases, stories, and pivot tables. JD Sartain

    Utilizing the Kind & Filters menu

    1. Entry the Violations desk. Click on the arrow beside the sector column known as Factors. Discover the drop-down menu begins with Kind Smallest to Largest or Kind Largest to Smallest. Select one in every of these sorting choices and spot that Excel types the desk utilizing the sector that your cursor resides on. For instance, in case your cursor is on the Factors area column, Excel types the desk by the Factors area.

    JD Sartain / PC World

    Use the Kind + Filters menus to kind fields

    2. In a small desk like this, it is easy to shortly see what number of Florida drivers have three, Four, or 12 factors. In actuality, nonetheless, this desk would possible have hundreds of data and many various ranges of factors. Utilizing the filters can be a a lot simpler and extra environment friendly strategy to decide what number of (and which) drivers have Better Than or Equal To 12 factors.

    Quantity Filters (one situation, one area)

    1. Click on the arrow beside the sector column known as Factors once more. Scroll down and choose Quantity Filters. From the submenu that pops up, choose Better Than or Equal To.

    2. When the Customized AutoFilter dialog window opens, discover the sector identify Factors is displayed below the immediate that claims Present Rows The place > Factors > Is larger than or equal to (your unique Logical Operator), which shows within the first Enter field.

    Recent Articles

    Related Stories

    Stay on op - Ge the daily news in your inbox