PDA

Click to See Complete Forum and Search --> : Excel - Finding Minimum Possible Positive Value


Fluxtrix
Oct 5th, 2005, 08:57 PM
Hi just wondering if the following is possible in excel to do the following with these colums:
A B C
52.7 46.28 1,705.57
8.5 69.04 -146.67
16.8 55.63 201.15
3.4 109.73 -360.39
41 47.53 1,215.27
67.5 45.32 2,325.78
6.7 76.32 -222.10
6 80.34 -251.44
7.6 72.25 -184.39
12.3 60.65 12.57
8.1 70.38 -163.43

Total Of Column B = 733.47

What i have done above, to achieve the values in column C is to multiply the values in Column A x Column B then subtract the total of Column B from this Figure.
What i would like to know is, can i automatically make excel adjust the values in column B to show the minimum positive value in column C?

This may not make sense, i hope i have explained it properly.. please any response would be much appreciated

malik641
Oct 10th, 2005, 01:05 AM
Do you mean sort the values in column C?

I'm not sure I understand what you mean by adjusting column B for a minimum value in C. Do you mean sort all the rows by the value in column C?