[Iska]

в моей версии 2016 офиса, походу, функции sort нету. »

Excel SORT function - auto sort data using formula:

Excel SORT function - tips and notes SORT is a new dynamic array function and as such it has a couple of specificities that you should be aware of: Currently the SORT function is only available in Microsoft 365 subscriptions. Excel 2019, Excel 2016 do not support dynamic array formulas, so the SORT function is not available in these versions. If the array returned by a SORT formula is the final result (i.e. not passed to another function), Excel dynamically creates an appropriately sized range and populates it with the sorted values. So, be sure you always have enough empty cells down or/and to the right of the cell where you enter the formula, otherwise a #SPILL error occurs. The results update dynamically as the source data changes. However, the array supplied to the formula does not extend automatically to include new entries that are added outside of the referenced array. To include such items, you need to either update the array reference in your formula, or convert the source range to an table as shown in this example, or create a dynamic named range. …