Forum Discussion
sort column descending - but not alphabetically
I have a column of data which I want to flip. So the bottom of the column becomes the top and the top becomes the bottom, but I don't want it to be alphabetically, I need the data in order, just flip...
To reverse the order of records in a table, you first need the array showing the current order 'k'. Then you output rows in descending order of k.
= LET(
k, SEQUENCE(ROWS(table)),
SORTBY(table, k, -1)
)Of course you need not leave messy formulas showing on the worksheet. You could use
= Reverseλ(table)