Use Excel SORT Formula in Hindi
Excel me data ko manually sort karna aasaan hai, lekin agar aap chahte hain ki data automatically sort ho jaye bina baar-baar Sort button use kiye, to aapko SORT Formula ka use karna chahiye.
2026 me Dynamic Array functions kaafi popular ho chuke hain, aur SORT function unme se ek important function hai.
Agar aap Data Entry Operator, MIS Executive ya Data Analyst banna chahte hain, to yeh formula aapko zaroor aana chahiye.
Excel SORT Function Kya Hai?
SORT ek dynamic array function hai jo kisi bhi data range ko automatically ascending ya descending order me sort kar deta hai.
Iska sabse bada fayda:
✔ Data change hote hi result automatically update ho jata hai
✔ Manual sorting ki zarurat nahi
✔ Professional reporting me useful
Excel SORT Function Ka Syntax
=SORT(array, [sort_index], [sort_order], [by_col])
Syntax Samjhein:
array → Jis data ko sort karna hai
sort_index → Kaunse column ke basis par sort karna hai
sort_order →
1 = Ascending
-1 = Descending
by_col → Column wise sort (optional)
Simple Practical Example (Ascending Order)
Maan lijiye A2:A6 me numbers hain:
| Marks |
| 75 |
| 90 |
| 60 |
| 85 |
| 70 |
Formula likhiye:
=SORT(A2:A6)
Result:
60
70
75
85
90
Data automatically ascending order me sort ho jayega.
Descending Order Example
Agar aap highest marks pehle dikhana chahte hain to:
=SORT(A2:A6,1,-1)
Result:
90
85
75
70
60
Yahan -1 ka matlab descending order hai.
Multiple Column Data Sort Karna
Maan lijiye A2:B6 me data hai:
| Name | Marks |
| Amit | 75 |
| Ravi | 90 |
| Sita | 60 |
| Mohan | 85 |
Agar aap Marks ke basis par sort karna chahte hain:
=SORT(A2:B6,2,-1)
Yahan 2 ka matlab second column (Marks) hai.
Result:
| Ravi | 90 |
| Mohan | 85 |
| Amit | 75 |
| Sita | 60 |
SORT vs Manual Sort Button
Manual Sort | SORT Formula |
| Static result | Dynamic result |
| Har baar click karna padta hai | Automatic update |
| Beginner use | Professional use |
SORT Function Kahan Use Hota Hai?
✔ Student Result Sheet
✔ Salary Sheet
✔ Sales Report
✔ Attendance Report
✔ MIS Reporting
✔ Inventory Management
Important Note
SORT function sirf Microsoft 365 aur latest Excel versions me available hai.
Conclusion
Excel SORT Formula ek powerful aur professional feature hai jo aapko automatic data sorting ki facility deta hai. Agar aap job oriented Excel training kar rahe hain to yeh function zaroor seekhein.
Agar aap Advanced Excel practical training lena chahte hain to join karein:
Excellent Computer Education
Indira Nagar, Lucknow
Job Oriented Data Analyst & MIS Executive Course Available.
