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.
Hello Tenspeed39355
Check out this link:
http://www.ozgrid.com/forum/archive/index.php/t-19105.html
Regds...
Niko
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.