PDA

View Full Version : [SOLVED] Invert numbers



Tenspeed39355
04-18-2005, 04:23 PM
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:dunno

Zack Barresse
04-18-2005, 04:42 PM
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
04-19-2005, 02:05 AM
Hello Tenspeed39355

Check out this link:

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

Regds...
Niko