🔹 Descending Order kya hai?

Descending Order ka matlab hota hai data ko bade se chhote (Large → Small) order mein arrange karna.

Excel mein Descending Order ka use tab kiya jata hai jab humein data mein highest value se lowest value tak information dekhni ho.

📌 Simple Example

Agar marks hain:

45
90
65
75
50

Descending Order mein:

90
75
65
50
45

Yaani sabse badi value → sabse chhoti value.

🔹 Different Data mein Descending Order

📌 Text Example

Normal data:

Amit
Rahul
Zoya
Karan

Descending Order:

Zoya
Rahul
Karan
Amit

Yaani Z → A.

🔹 Excel mein Descending Order kaise lagaye?

Method: Sort & Filter

1. Apna data select karein.
2. Data tab par click karein.
3. Sort & Filter section mein jayein.
4. Z to A option select karein.
5. Numbers ke case mein Excel data ko Largest to Smallest arrange karega.

📊 Example – Student Marks

Descending Order:

Isse humein easily pata chal jata hai ki highest marks kis student ke hain.

🔹 Descending Order ka Practical Use

Descending sorting ka use real-life Excel work mein bahut common hai:

• 🏆 Highest marks se lowest marks
• 💰 Highest salary se lowest salary
• 🛒 Highest price se lowest price
• 📈 Highest sales se lowest sales
• 📊 Highest percentage se lowest percentage
• ⭐ Highest rating se lowest rating
• 📅 Latest date se oldest date
• 📦 Highest quantity se lowest quantity
• 💵 Highest profit se lowest profit

⚠️ Important Point

Agar aapki table mein multiple columns hain, to sirf ek column ko sort na karein.

Example:

Marks ko Descending Order mein sort karte waqt poori table ko sort karein, taki student ke marks aur grade ka connection na toot jaye.

🔄 Ascending vs Descending