🔃 Dynamic Sorting

Goal: Reorder the table automatically.
SORT creates a new dynamic copy of your data in the requested order.

Source Data (A1:B5):
Result (Spill Range):
(Select a sort option...)
Ready...

💻 Formula Structure

=SORT(array, [sort_index], [sort_order])
  • 1. Array: The range to sort (A2:B5).
  • 2. Sort Index: Which column number to sort by? (1 or 2).
  • 3. Sort Order: 1 = Ascending (A-Z), -1 = Descending (Z-A).
-- Select an option...
=SORT( ... )
Top Result:
-

⚠️ Common Pitfalls

🚫 Sorting in Place
The SORT function does NOT change the original cells. It creates a new list elsewhere. To sort in place, use the Data tab filters.
🚫 #SPILL! Error
Ensure the cells below the formula are empty so the data has room to expand.