Invert a column of number

  • Thread starter Thread starter Wayne Burritt
  • Start date Start date
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
 
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
 
Back
Top