📋 GS-SORT

 
=SORT(range, sort_column, is_ascending)
    
Example:
=SORT(A2:C10, 2, TRUE)
    

Sorts the data in range A2:C10 based on the 2nd column in ascending order.

 
Organizes rows in a range based on specified column(s), either ascending or descending.
    

E.g., Sort student scores by subject, or reorder a product inventory list by quantity.
    

Try in Google Sheets:
- Column A: Names
- Column B: Scores
 
Use:
=SORT(A2:B10, 2, FALSE)

This sorts by Scores from highest to lowest.
    

✅ HR: Sort employees by hire date or salary  
✅ Finance: Order expenses from highest to lowest  
✅ Marketing: Rank campaigns by conversion rate  
✅ Education: List students by performance  
✅ Logistics: Prioritize deliveries by urgency
    

❌ #REF! error: Overlapping output range  
✅ Fix: Place SORT in an empty area or use ARRAYFORMULA safely

❌ Unexpected order: Wrong sort_column index  
✅ Fix: Ensure the column index matches the actual range
    

🧠 7. Bonus Tips

💡 Combine with FILTER to sort only filtered rows  
💡 Use SORTN to limit results to top N entries  
💡 Nest SORT inside QUERY for advanced sorting
    

🗂️ 8. Navigation

Next Formula → 1.2 🔍 GS Sort Sheet  
Previous Formula ← None (This is the first formula)