ExcelHeroThe SORT function
Sorts a range.
In German Excel: SORTIEREN
How to write it
=SORT(array, [sort_index], [sort_order])- array
- The range.
- sort_index
- Which column to sort by.
- sort_order
- 1 ascending, -1 descending.
💡 Wrap it around UNIQUE or FILTER for tidy lists.
Try it
List the scores from lowest to highest.
A
B
C
D
1
Student
Score
Sorted
2
Aisha
88
3
Ben
54
4
Chloe
97
5
Dev
71
6
Emma
63
7
Finn
79
=SORT(range) sorts low to high.