Jamey Weare
12/19/2006 7:47:00 PM
I just put my cursor on the dd cell and hit sort Ascending and it gave
me the results you are looking for.
On Dec 19, 2:40 pm, "Anna" <colleen1...@gmail.com> wrote:
> Hi: This is my data. Can any one please tell me how to i sort it so
> that the codes which have no any value will be go bottom
>
> Raw Data
> Code Name Address
> 1 dd ff
> 2
> 3
> 4 ss gg
>
> Output required
> Code Name Address
> 1 dd ff
> 4 ss gg
> 2
> 3
>
> Thanks.