How to Use the FILTER Formula

🎯 Purpose of FILTER Formula

The FILTER function helps you extract only the rows that meet specific criteria from a range or table in Excel.

---

🔢 Syntax

excel =FILTER(array, include, [if_empty])

---

🧩 Example Dataset

Name	Department	Salary
Aditi	HR	45000
Rahul	Finance	55000
Meena	HR	52000
Vivek	IT	60000
Neha	Finance	48000

---

🔁 Step-by-Step Process Flow

✅ Step 1: Identify the Data Range

• Choose the range to filter.
  👉 Here, the full data is in A2:C6.

✅ Step 2: Choose Filtering Criteria

• Decide what condition you want to apply.
  👉 For example: Department = "HR"

✅ Step 3: Apply the FILTER Formula

• In a blank cell, type:

excel =FILTER(A2:C6, B2:B6="HR", "No HR Employees Found")

• This filters rows where column B (Department) is “HR”.

✅ Step 4: View the Output

• Excel will automatically spill the matching rows below the formula cell:

| Aditi | HR | 45000 | | Meena | HR | 52000 |

View Sample Video: