I have an inventory stock report that I am attempting to sort by
priority of what needs to be done daily. I am trying to avoid a double
sort of the entire worksheet by writing a formula. In the attached file
is my sample data. If possible i want to be able to sort the entire file
by the %Neg collum.

The formula for the %Neg collum is:
=IF(D120,(D12/E12),IF(D12<0,((D12/E12)/1),))


What I am attempting to accomplish is: If I2 is Negative then sort from
Highest to Lowest. If I2 is positive then sort from Lowest to Highest.

Any help is appreciated!


+-------------------------------------------------------------------+
|Filename: Sample.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4410 |
+-------------------------------------------------------------------+

--
Remotruker
------------------------------------------------------------------------
Remotruker's Profile: http://www.excelforum.com/member.php...o&userid=32082
View this thread: http://www.excelforum.com/showthread...hreadid=518379