Formulas

How to use the Filter function

Pinterest LinkedIn Tumblr

Ever thought!! how to filter a huge data set? Well, you are in the right place. In this article, we will be discussing everything you need to know about Filter. So, Let’s see how it works.

Filter function – Introduction

Basically, Filter function enables a user to instantly filter a huge data set, based on a condition and pull out the information to another location or somewhere in the same worksheet. In most cases, this function acts as a huge time saver. If you are quite familiar with Excel functions, you can use the filter function to filter the data based on the criteria.

The fastest way to access the filter function is by selecting the data tab in the ribbons and clicking on the Filter option. Alternatively, we can also use the shortcut key Shift+Ctrl+L. The Filter Functions are available only in Microsoft 365.

SYNTAX OF FILTER FUNCTION:

=FILTER (array, include, [if_empty])

Here we have some Electronic components under Products, Say suppose you want to filter only the Wireless Keyboard from the product list. The below steps will guide you to process the filtering.

FILTER FUNCTION_1

The steps are as follows:

Step 1: Type =FILTER(
Step 2: In the following example, we use the formula = FILTER(B4: D18, C4: C18=G3,) to return all records for a wireless keyboard.
Step 3: Click Enter and you can see the data filtered.

FILTER FUNCTION_2

You can FILTER based on multiple criteria with the help of (*) operator.

To read more related articles click here

Subscribe to our YouTube channel for regular updates.

Practise Files

Related Posts

Write A Comment