🔹 Multiple-Column Sorting kya hai?

Multiple-Column Sorting ka matlab hai Excel mein data ko ek se zyada columns ke basis par sort karna.

Ismein hum ek main/primary column choose karte hain aur uske andar same values hone par second column ke basis par sorting karte hain.

👉 Simple words mein: Pehle Column 1 ke according sorting, phir same data mein Column 2 ke according sorting.

📊 Simple Example

Maan lijiye student data hai:

Agar hum:

1st Level: Class → Ascending
2nd Level: Marks → Descending

lagate hain, result hoga:

Yahan pehle Class ke according sorting hui. Phir same class ke students ko Marks ke according arrange kiya gaya.

🔹 Primary aur Secondary Sorting

Multiple-column sorting mein generally do important levels hote hain:

1. Primary Sort

Ye main column hota hai jiske basis par sabse pehle data arrange hota hai.

2. Secondary Sort

Agar Primary column mein same values aa jayein, to un records ko second column ke basis par arrange kiya jata hai.

📌 Example

Sorting:

Department → A to Z
Salary → Largest to Smallest

Result:

🔹 Excel mein Multiple-Column Sorting kaise karein?

Step 1

Apni complete table select karein.

Step 2

Data → Sort par click karein.

Step 3

Sort window mein Sort by se primary column select karein.

Example:

Sort by: Department
Order: A to Z

Step 4

Add Level par click karein.

Step 5

Second column select karein.

Then by: Salary
Order: Largest to Smallest

Step 6

OK par click karein.

Excel pehle Department ke according sorting karega aur phir same Department ke records ko Salary ke according arrange karega.

📋 Example – Sales Data

Sorting:

City → A to Z
Sales → Largest to Smallest

Result: