Inverting a column of data

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi, I have a column of data going from 1 to 10, what I'd
like to do is invert it so 10 becomes 1, 9 becomes 2 etc
etc. Does anyone know how to do this.

Cheers.
 
Neil

Use a helper colum. Enter =ROW(), copy down, then copy and paste
special/values. You can then sort this helper column A-Z or Z-A as you wish

Andy.
 
Assume your data is in A1:A10, put this formula in cells B1:B10

=OFFSET($A$1,10-ROW(),0)

Then select B1:B10, copy and Paste Special:Values

HTH

-Dave
 
Back
Top