Sorting

[Patrick]

I would like to sort a column of names
D:1=Joe H
D:2=Pete I
D:3=Tory N
D:4=Etc....

there are formulas involved in
D:1=IF(C1=0," ",C1) to arrive at Joe H
etc
The sorting is not to working can anyone tell me why....please

 

[Russell Hauf]

On 2002-03-11 17:02, Patrick wrote:
I would like to sort a column of names
D:1=Joe H
D:2=Pete I
D:3=Tory N
D:4=Etc....

there are formulas involved in
D:1=IF(C1=0," ",C1) to arrive at Joe H
etc
The sorting is not to working can anyone tell me why....please

Try sorting Column C instead.

-rh

 

[Patrick]

column c also has formulas in the cells..
however I guess I figuered it out.. column D needed the cells to be formatted as text...
and it works!!
thanks anyhow