View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default 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