Thread: Custom Sort
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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