Custom Sort
You would need to use a helper column that will be your first sort key. Put
a formula in that column that will produce a result that sorts to the bottom
if the referenced column contains a zero.
=if(c2=0,"Z","A")
drag fill down the dummy column.
--
Regards,
Tom Ogilvy
"Rafi" wrote in message
...
How do I sort a range on a column with numbers (integers) so that all
record
having a zero in that column will be at the end of the list.
Thanks
|