Sorting data to put "0's" last
I have a worksheet which has names paste linked from another workbook. The
rows all default to "0" til a name is filled in on the other workbook for
that cell. Not all the rows will end up with a name in them so when I go to
sort the worksheet once all names that are to be entered over time have been
done I get all the "O" rows at the top and then the names alphabetically
sorted after that. How can I get all the "0" rows to go to the bottom of the
sorted list.
|