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...
chealy79 I think you can handle it via SORTBY, for example, this is one way of doing it for the following sample, I would suggest next time share your sample data in an Excel file, so we can accommodate the solution to your specific problem:
=SORTBY(A1:B3,-SEQUENCE(ROWS(A1:A3)))
Here is a sample:
You can also use ROW for a sorter approach:
=SORTBY(A1:B3,-ROW(A1:A3))
I hope it helps,
David