How to convert a list in reverse order on excel sheet

Question

I wrote some values ​​in a column and I want to do it in reverse order.

Answer 1

• Insert a column next to the column you want to sort.
• In the top cell in the new column, add 1 to the first cell, 2 to the second cell, etc., until you reach the bottom cell.
• Select both the original column and the new column with numbers
• Go to Data> Sort
• Sort by new column, descending.
• All is ready!

NOTE. If you want to know how to do this using VBA code, specify in your quesiton. Otherwise, it will answer your question, and it really applies to superuser.com

Answer 2

Suppose you want to invert the range E1: E6 and put the inverted list in the range F1: F6.

Enter this array formula in F1. (This is an array formula, so you must press CTRL + SHIFT + ENTER)

=OFFSET($E$1:$E$6,MAX(ROW($F$1:$F$6))-ROW(),0) 

Then select the entire F1: F6 range and use Fill Down (Home / Editing tab) to copy this formula to all cells in the F1: F6 range.

Answer 3

You can add an additional column with numbers 1,2,3, .... N. Then you use this column to sort the area that includes your data in the reverse order (descending).

Answer 4

Why use the Offset or array formula? Why not use "= ($ E1- (MAX ($ E $ 2: $ E $) + 1)) * - 1", enter this in cell F1 and copy. There is no array formula, no bias, cleaning and simplification, IMHO.