View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
C. Corodan C. Corodan is offline
external usenet poster
 
Posts: 9
Default Sort when I have blank cells

Hello,

I am trying to sort ascending a range containing blank cells. After sorting,
the blank cells will be displayed on top and the cells woth text at the end.

e.g, if I sort column A1:A10, I get B1:B10.

A B C
1 1
3 2
3
4 4
2 1 5
2 6
3
6 4
5
5 6


What should I do to hace an ascending sorted range displaying the cells with
text first and the empty cells at the bottom, as in C1:C10?

Thanks,