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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I invert a column of numbers? (make the 1st last, etc) (https://www.excelbanter.com/excel-discussion-misc-queries/114661-how-do-i-invert-column-numbers-make-1st-last-etc.html)

Glockner

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

garfield-n-odie [MVP]

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

See
http://groups.google.com/group/micro...5ae4fdfd999222
..

Glockner wrote:

Gord Dibben

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

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

On Mon, 16 Oct 2006 13:45:01 -0700, Glockner
wrote:

All times are GMT +1. The time now is 12:40 PM.