FILTER Function in Excel – Multiple Criteria ke Sath Data Filter Kaise Kare

Excel ka FILTER function ek dynamic array function hai jo kisi range se multiple conditions (criteria) ke basis par data ko turant filter karke naya result show karta hai. Isme original data change nahi hota, balki filtered result automatically update hota rehta hai jaise hi data change hota hai.

FILTER Function ka Basic Syntax

=FILTER(array, include, [if_empty])

array → wo data range jisko filter karna hai

include → logical condition (TRUE / FALSE)

if_empty → agar koi record match na ho to kya show karna hai (optional)

Multiple Criteria ke Sath FILTER ka Use

Jab hume ek se zyada condition lagani hoti hai (jaise Department + Salary, City + Status), tab logical operators ka use hota hai:

AND condition → * (multiplication)

OR condition → + (addition)

Example (AND condition):
Department = "Sales" aur Salary 30000

=FILTER(A2:D20,(B2:B20="Sales")*(C2:C20 30000),"No Data Found")
Example (OR condition):
City = "Delhi" ya City = "Mumbai"

=FILTER(A2:D20,(D2:D20="Delhi")+(D2:D20="Mumbai"),"No Match")

FILTER Function ke Fayde

Auto-update hota hai (dynamic result)

Advanced Filter ya helper column ki zarurat nahi

Clean aur fast data analysis

Dashboard aur reports ke liye best

Kab Use Kare

Large data me quick filtering chahiye

Multiple criteria ke sath analysis

Excel Dashboard / MIS reports banate time

Note: FILTER function Excel 365 aur Excel 2021+ versions me available hai.

Ye function specially Advanced Excel, Data Analysis aur MIS reporting ke liye bahut powerful hai.

Видео FILTER Function in Excel – Multiple Criteria ke Sath Data Filter Kaise Kare канала IT TECH