🔹 Custom AutoFilter kya hai?

Custom AutoFilter Excel ka ek advanced filtering option hai jisme hum apni specific condition ke according data ko filter kar sakte hain.

Normal AutoFilter mein hum list se value select karte hain, lekin Custom AutoFilter mein hum conditions jaise:

• Greater Than >
• Less Than <
• Equal To =
• Greater Than or Equal To >=
• Less Than or Equal To <=
• Does Not Equal <>
• AND
• OR

ka use kar sakte hain.

👉 Simple words mein:

Custom AutoFilter ka use specific conditions ke basis par required data find karne ke liye hota hai.

📊 Simple Example

Maan lijiye students ke marks hain:

Agar humein 80 se zyada marks wale students chahiye, to Custom AutoFilter mein condition laga sakte hain:

Marks → Greater Than → 80

Result:

🔹 Custom AutoFilter kaise lagaye?

Step 1

Apne data par AutoFilter apply karein.

Data → Filter

Step 2

Jis column par condition lagani hai uske ▼ arrow par click karein.

Step 3

Number Filters ya Text Filters select karein.

Step 4

Custom Filter option choose karein.

Step 5

Apni required condition select karein.

Example:

Greater Than
80

Step 6

OK par click karein.

Excel sirf condition ko satisfy karne wale records show karega.

🔢 Number Filters

Numbers ke saath Custom AutoFilter bahut useful hai.

Common conditions:

📌 Example

Agar Sales data hai:

Condition:

Sales Greater Than ₹40,000

Result:

🔤 Text Filters

Custom AutoFilter ka use text ke saath bhi kiya ja sakta hai.

Common options:

• Equals
• Does Not Equal
• Begins With
• Ends With
• Contains
• Does Not Contain

📌 Example

Agar City column mein:

Delhi
Mumbai
Delhi
Pune
Delhi

Condition:

City → Equals → Delhi

Result mein sirf Delhi ke records show honge.

🔗 AND Condition

AND ka matlab hai dono conditions satisfy honi chahiye.

Example:

Marks > 70
AND
Marks < 90

Iska matlab hai marks 70 se greater aur 90 se less hone chahiye.

Agar marks hain:

65
75
82
95

Result:

75
82

🔀 OR Condition

OR ka matlab hai koi bhi ek condition satisfy ho sakti hai.

Example:

Marks < 50
OR
Marks > 90

Agar marks hain:

45
60
75
92
95

Result:

45
92
95

📊 Practical Business Example

Maan lijiye sales report hai:

Agar humein ₹30,000 se ₹70,000 ke beech ki sales chahiye:

Custom AutoFilter:

Greater Than or Equal To → 30000
AND
Less Than or Equal To → 70000

Result:

🎯 Custom AutoFilter ke Practical Uses

Custom AutoFilter ka use:

• 📊 Sales analysis
• 👨‍🎓 Student marks analysis
• 💰 Salary records
• 📦 Inventory management
• 🧾 Invoice data
• 📅 Date-based reports
• 👥 Employee records
• 💵 Profit analysis
• 📈 Business reporting

mein kiya jata hai.

🔄 AutoFilter vs Custom AutoFilter