Thread: How do I invert a column of numbers? (make the 1st last, etc)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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:


Reply With QuoteReply With Quote