Thread: Sorting zeros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kunst101 kunst101 is offline
external usenet poster
 
Posts: 1
Default Sorting zeros

Im wanting to sort a series of lists that contain zeros, positive and
negative numbers also. I want the zero's to be excluded from the sort. I
have also built formulas to ommitt the zeros and pasted special values and
the sort continues to seperate the positive from the negative by the gap
created by the zeros. Any other suggestions?