Inverting a column of data

[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.

 

[Andy B]

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.

 

[Dave Smith]

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