How do I invert a column of numbers? (make the 1st last, etc)

  • Thread starter garfield-n-odie [MVP]
  • Start date
G

Gord Dibben

Assuming numbers are in column A

In B1 enter 1

Right-click and drag down to bottom of original list in column A

Release button and "Fill Series"

Sort on that new column in descending order.

When happy, delete that column.


Gord Dibben MS Excel MVP
 
Top