🔹 Filtering by Criteria kya hai?

Filtering by Criteria ka matlab hai Excel mein kisi specific condition (criteria) ke basis par data mein se sirf required records ko display karna.

Simple words mein:

Jab hum kisi condition ke according data ko filter karte hain, use Filtering by Criteria kehte hain.

For example, agar 500 students ka data hai aur humein sirf 80 se zyada marks wale students dekhne hain, to Marks > 80 ek filtering criterion hai.

📊 Simple Example

Maan lijiye student data hai:

Criteria:

Marks > 80

Filtered result:

Baaki records delete nahi hote, sirf temporarily hide ho jate hain.

🔹 Criteria kya hota hai?

Criteria ka matlab hota hai woh condition ya rule jiske basis par Excel data ko filter karta hai.

Examples:

City = Delhi
Marks > 80
Salary >= ₹30,000
Sales < ₹50,000
Department = Sales
Name begins with "A"

🔢 Number ke Basis par Filtering

Numbers ko different conditions ke according filter kar sakte hain.

📌 Example

Sales data:

Criteria:

Sales > ₹50,000

Result:

🔤 Text ke Basis par Filtering

Text data ko bhi criteria ke according filter kar sakte hain.

Examples:

• City = Delhi
• Department = Sales
• Name begins with A
• Product contains “Laptop”
• City does not equal Mumbai

📌 Example

Criteria:

Department = Sales

Result:

📅 Date ke Basis par Filtering

Dates ko bhi criteria ke according filter kiya ja sakta hai.

Examples:

• Today’s records
• This month’s records
• After a particular date
• Before a particular date
• Between two dates

Example:

Date ≥ 01-09-2026

Isse 1 September 2026 ya uske baad ke records display honge.

🔗 Multiple Criteria

Excel mein ek se zyada criteria bhi use kiye ja sakte hain.

AND Condition

Dono conditions satisfy honi chahiye.

Marks > 70
AND
Class = 10th

Result mein sirf 10th class ke students jinke marks 70 se zyada hain show honge.

OR Condition

Koi bhi ek condition satisfy ho sakti hai.

City = Delhi
OR
City = Mumbai

Isse Delhi ya Mumbai ke records show honge.

🛠️ Excel mein Filtering by Criteria kaise karein?

Method 1 – AutoFilter

1. Data select karein.
2. Data → Filter par click karein.
3. Required column ke ▼ arrow par click karein.
4. Required value ya condition select karein.
5. OK par click karein.

Method 2 – Custom Filter

Agar specific condition lagani hai:

Filter Arrow → Number Filters / Text Filters → Custom Filter

Example:

Marks → Greater Than → 80

🎯 Practical Applications

Filtering by Criteria ka use:

• 👨‍🎓 Student Data: Marks > 80
• 💰 Salary Data: Salary > ₹30,000
• 📊 Sales Data: Sales > ₹50,000
• 📦 Inventory: Quantity < 10
• 👥 Employee Data: Department = HR
• 📅 Transaction Data: Date = September
• 🏪 Customer Data: City = Delhi

🔄 Filtering vs Sorting