Invert a column of number

W

Wayne Burritt

Hi: I have a column of 100 numbers in a specific order. I need to invert
them. They are not in ascending or descending, order so the sort function
is out. Any ideas? thanks, Wayne
 
C

cornutty

Easy. Insert a new column A. Then number the newly added
column 1 thru 100 (use fill down to populate). Then sort -
descending if you wish- on the newly added column.

Your data will then appear in reverse, inverted, order.

~Nutty
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invert a column of numbers 2
Invert a column 5
Invert 2
Is there a way to transpose and invert the order of data in Excel. 1
How do I invert an Excel table (collumns become rows)? 1
how do i flip a column round in excel? 4
Manipulating matrices of unknwon (a priori) size 1
Can I invert a table so row headings are now column headings etc 3

Top