An easy but clunky way to do this is to do it on another sheet.
E.g. On sheet2 you have =sort()
commands that reference sheet 1.
Leave room.
E.g. Sheet2:B3 has the formula =sort(Sheet1!B3:C9,2,FALSE)
Better: Define named ranges for each of the sources. This allows you to reference the named ranges in sheet2. When you extend one in Sheet1, you don't have to change sheet2, unless you collide with another range.
If you add a row IN the range on sheet1, the ranges that include that row update automatically. The area used by the sorted ranges on sheet 2 does not update, so you will eventually get collision errors as tries to stomp on the next block.
You can put these on the same sheet too.
Thus the =sort
goes to a blank part of the sheet to the right of the top of the block it's sorting. This will create room as rows are added. The downside of this is a spread out layout that requires lots of spacing
E.g.
B3 C3 {bunch of other columns} Q3=sort(B_Range,2,FALSE)
B4 C4
B5 ...
You can make a new sheet and on this one, create a formula A1=Q1
and replicate that down and across. This will give you the effect of having a separate tab for the sorted data.
You can hide the sorted data on the first sheet if you wish.
Try:
=sort(filter(Leaderboard1!E5:F126, len(Leaderboard1!E5:E126)),1,True)
Best Answer
An example could be
SORTN
restricted byINDEX
where the 3rd parameter ofSORTN
is2