Assume the 100 elements I mentioned are in column A. Then, in column B, proceed as follows:
In B1, add the formula =ABS(A1)
In B2, add the formula =ABS(A2)
In B3, add the formula =ABS(A3)
Then select the three cells B1:B3
Grab the bottom right corner and drag it to the bottom of the column at B100. The formulas should progress in numerical order to =ABS(A100).
I know it isn't what you want, but it's all I know.
Last edited by bigrigdriver; 06-09-2012 at 05:14 PM.