Invert numbers

[Tenspeed39355]

I have a column of numbers. How do I invert the numbers?
Example 1 2 3 4 5 5 4 3 2 1
I can not find the invert command in excel
Thanks for your help
Max

[Zack Barresse]

Well, without getting really fancy, you could use standard worksheet functions. If you had 1 in A1 and 2 in A2, etc, all the way down to 5 in A5, then in B1:B5 you could enter this formula (with B1 selected) ...

=INDEX(A:A,ROW($A$5)-ROW()+1)

Then confirm with Ctrl + Enter. This will get you what you are asking for. This can be adapted really for any cells.

[Niko]

Hello Tenspeed39355

Check out this link:

http://www.ozgrid.com/forum/archive/...p/t-19105.html

Regds...
Niko