Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting zeros
Maybe this would be acceptable:
Set up AutoFilter, then use the 'Custom' option to set up to display only values that are Not Equal to zero. Sort and you won't have any zeros in the list. "kunst101" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Omitting Zero's in Formula's | Excel Discussion (Misc queries) | |||
Macro Help replacing dropped zeros | Excel Discussion (Misc queries) | |||
Custom sorting with Letters and Zeros | Excel Discussion (Misc queries) | |||
Leading Zeros | Excel Discussion (Misc queries) | |||
Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) |