Sorting

Patrick · Mar 11th, 2002, 06:02 PM

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 · Mar 11th, 2002, 06:14 PM

Quote:

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 · Mar 11th, 2002, 06:19 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 06:02 PM	#1
Patrick Board Regular Join Date: Mar 2002 Location: Canada Posts: 50	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

Mar 11th, 2002, 06:19 PM	#3
Patrick Board Regular Join Date: Mar 2002 Location: Canada Posts: 50	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