🔹 Criteria Range kya hai?

Criteria Range Excel mein ek separate range of cells hoti hai jahan hum data ko filter karne ke liye conditions ya rules define karte hain.

Ye mainly Advanced Filter ke saath use hoti hai.

Simple words mein:

Criteria Range batati hai ki Excel ko kaunsa data filter karke dikhana hai.

📊 Simple Example

Maan lijiye hamara main data hai:

Humein sirf 10th class ke students jinke marks 80 se zyada hain chahiye.

Iske liye Criteria Range:

Yahan:

• Class = 10th
• Marks = >80
• Dono conditions ek hi row mein hain, isliye AND condition banegi.

Result:

🔹 Criteria Range ke Main Parts

Criteria Range mein generally do cheezein hoti hain:

1. Field Name / Heading

Criteria Range ke headings main data ke headings ke same hone chahiye.

Example:

Main data:

Student | Class | Marks

Criteria Range:

Class | Marks

2. Criteria / Condition

Heading ke neeche actual condition likhi jati hai.

Example:

Class → 10th
Marks → >80

🔗 AND Condition in Criteria Range

Agar conditions same row mein likhi hain, to Excel unhe generally AND condition ke roop mein treat karta hai.

Example:

Meaning:

Class = 10th AND Marks > 80

🔀 OR Condition in Criteria Range

Agar conditions different rows mein likhi hain, to Excel unhe generally OR condition ke roop mein treat karta hai.

Example:

Meaning:

Class = 10th AND Marks > 90

OR

Class = 9th AND Marks > 80

📌 Text Criteria Example

Main data:

Criteria Range:

Result mein sirf Sales Department ke employees show honge.

🔢 Number Criteria Example

Sales data:

Criteria Range:

Result:

📅 Date Criteria Example

Maan lijiye transaction data hai:

Criteria Range:

Isse 10 September 2026 ya uske baad ke records filter kiye ja sakte hain.

🛠️ Criteria Range kaise banayein?

Step 1

Main data ke headings ko identify karein.

Step 2

Main table ke bahar ek blank area choose karein.

Step 3

Required column heading ko same spelling ke saath likhein.

Step 4

Heading ke neeche required condition enter karein.

Example:

Class     Marks
10th      >80

Step 5

Data → Advanced par click karein.

Step 6

• List Range → Main data
• Criteria Range → Criteria Range

Select karein.

Step 7

OK par click karein.

⚠️ Important Rules

Rule 1 – Heading Same Honi Chahiye

Main data:

Marks

Criteria Range:

Marks

❌ Student Marks likhne par expected filtering nahi ho sakti.

Rule 2 – Criteria Heading ke Neeche Likhein

Correct:

Incorrect:

Rule 3 – AND aur OR ko Samjhein

Same Row → AND

Different Rows → OR

🎯 Criteria Range ke Practical Uses

Criteria Range ka use:

• 📊 Sales filtering
• 👨‍🎓 Student result analysis
• 👥 Employee records
• 💰 Salary data
• 📦 Inventory management
• 🧾 Invoice records
• 📅 Date-wise reports
• 🏪 Customer database
• 📈 Business analysis

mein kiya jata hai.

🔄 Criteria Range vs Filter