Conditional Sorting
I haven't opened your file, but I assume column I is the same as %Neg
that you refer to. When you say:
If I2 is Negative then sort from Highest to Lowest.
do you mean "most negative" for Highest? i.e. is -100 "higher" than -10
? If so, can't you just sort on this column in ascending order, so you
go from -100 to -10 to +10 to +100?
Or, do you mean that you want the sort order to go -10, -100, +10, +100
?
Please clarify.
Pete
|