Sorts the contents of a range or array.
تعمل هذه الدالة في Google Sheets كما تعمل في Excel تمامًا — بالصياغة والوسائط نفسها.
SORT(array, [sort_index], [sort_order], [by_col])The SORT function returns a sorted version of an array or range. It allows you to specify the column or row index to sort by, the sort order (ascending or descending), and whether to sort by row or by column.
=SORT(A2:B5, 2, -1)النتيجة: Sorted array
Sorts the range A2:B5 based on the second column in descending order.
No, SORT returns a dynamic array and does not change the source data.