🔹 Criteria Based Data Entry kya hai?

Criteria Based Data Entry ka matlab hai Excel mein data enter karte waqt pehle se defined conditions/rules ke according hi data enter karna.

Iska main purpose hota hai ki user sirf valid aur required data enter kare aur गलत या unwanted data entry ko roka ja sake.

👉 Excel mein Criteria Based Data Entry ke liye Data Validation ka use kiya jata hai.

1. Criteria kya hota hai?

Criteria ka matlab hota hai condition ya rule jiske basis par data accept ya reject kiya jata hai.

Example:

Agar Student Marks ki entry karni hai, to criteria ho sakta hai:

Marks 0 se 100 ke beech hone chahiye.

Yahan 110 invalid hai kyunki defined criteria 0–100 hai.

2. Criteria Based Data Entry ka use kyun karte hain?

Iska use mainly:

• ❌ Wrong data ko prevent karne ke liye
• ✅ Data accuracy maintain karne ke liye
• 📋 Fixed options provide karne ke liye
• 🔽 Dropdown list banane ke liye
• 📊 Data analysis ko easy banane ke liye
• 🧹 Duplicate/invalid entries ko reduce karne ke liye
• 💼 Professional Excel sheets banane ke liye

3. Criteria Based Data Entry ke Examples

📌 Example 1 – Marks

Criteria:

Marks 0 se 100 ke beech hone chahiye.

Minimum = 0
Maximum = 100

100 ✅
75 ✅
0 ✅
105 ❌
-10 ❌

📌 Example 2 – Age

Criteria:

Age 18 se 60 ke beech honi chahiye.

Minimum = 18
Maximum = 60

25 ✅
40 ✅
17 ❌
65 ❌

📌 Example 3 – Department

Agar employee ka department sirf kuch fixed options mein se select karna ho:

HR
IT
Sales
Marketing
Accounts

To user manually kuch bhi type karne ke bajay Dropdown List se option select kar sakta hai.

4. Data Validation se Criteria Set karna

Steps:

Step 1: Required cells select karein.

Step 2:
Data → Data Validation

Step 3: Allow option mein required criteria select karein.

For example:

Allow: Whole Number
Data: between
Minimum: 0
Maximum: 100

Step 4: OK par click karein.

Ab selected cells mein sirf 0–100 ke beech values enter ki ja sakengi.

5. Common Criteria Types

6. Criteria Based Dropdown

Dropdown criteria-based data entry ka ek important example hai.

Example:

Gender

Male
Female
Other

User ko manually type karne ki zarurat nahi hoti. Dropdown se option select kar sakta hai.

Benefits:

• Spelling mistakes kam hoti hain
• Data consistent rehta hai
• Entry fast hoti hai
• Reporting easy hoti hai

7. Date Based Criteria

Excel mein dates ko bhi criteria ke according restrict kiya ja sakta hai.

Example:

Admission Date sirf:

01/01/2026 se 31/12/2026 ke beech honi chahiye.

Start Date = 01/01/2026
End Date   = 31/12/2026

Is range ke bahar ki date invalid ho jayegi.

8. Custom Criteria

Kabhi-kabhi simple criteria sufficient nahi hota. Aise cases mein Custom Formula ka use kiya ja sakta hai.

Example:

Agar cell mein sirf numbers allow karne hain:

=ISNUMBER(A2)

Agar condition TRUE hoti hai, entry valid hai.

9. Error Alert

Agar user invalid data enter karta hai, Excel Error Alert show kar sakta hai.

Example:

❌ Invalid Entry
Please enter marks between 0 and 100.

Error Alert ke common styles:

• Stop – Invalid entry ko completely stop karta hai.
• Warning – Warning deta hai.
• Information – Information message show karta hai.

10. Practical Example – Student Data

Criteria:

Marks: 0–100
Course: Dropdown
Admission Date: Valid date range

Isse student data mein गलत entries ke chances kam ho jate hain.

⭐ Practical Applications

Criteria Based Data Entry ka use:

• 🎓 Student Registration
• 📚 Exam Marks
• 👨‍💼 Employee Records
• 💰 Fee Management
• 📦 Inventory Management
• 🛒 Sales Records
• 📅 Attendance
• 📞 Customer Database
• 🏢 Office Records
• 💳 Payment Records

🔄 Normal Entry vs Criteria Based Entry