3 level sort, last special order
 

Hi Group,
I have a spread sheet which I am sorting by 3 levels, all of which are
ascending. The last level of sort is based on Options with a specific list,
which is not alphabetical anymore, but it does not seen to work and puts it
in alpha order anyway. Are "special" sort orders only good for the first
level of sort?

--
David

3 level sort, last special order
 

Do the special sort on the other two columns, then do another sort on the
column with the specific list.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David" wrote in message
...
Hi Group,
I have a spread sheet which I am sorting by 3 levels, all of which are
ascending. The last level of sort is based on Options with a specific
list,
which is not alphabetical anymore, but it does not seen to work and puts
it
in alpha order anyway. Are "special" sort orders only good for the first
level of sort?

--
David

3 level sort, last special order
 

Hi,
I am not sure what you mean. The first sort is by "W/O Num" with no
"special" order, the second sort is by "Customer", again with no special
order, then the last sort is by "Labor/Part/Misc", which is based on a list
and is the special sort order, " "Labor ***", "Parts ***", "Misc. ***" ". In
the last part of the sort, it puts it in alpha order, " "Labor ***", "Misc.
***", "Parts ***" ".

I have tried choosing "special" at all the levels, but still no sucess.
--
David


"Bob Phillips" wrote:

Do the special sort on the other two columns, then do another sort on the
column with the specific list.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David" wrote in message
...
Hi Group,
I have a spread sheet which I am sorting by 3 levels, all of which are
ascending. The last level of sort is based on Options with a specific
list,
which is not alphabetical anymore, but it does not seen to work and puts
it
in alpha order anyway. Are "special" sort orders only good for the first
level of sort?

--
David

3 level sort, last special order
 

What I mean is do one sort using the two non-special columns. Then do
another sort, this time only keyed on the special column.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David" wrote in message
...
Hi,
I am not sure what you mean. The first sort is by "W/O Num" with no
"special" order, the second sort is by "Customer", again with no special
order, then the last sort is by "Labor/Part/Misc", which is based on a
list
and is the special sort order, " "Labor ***", "Parts ***", "Misc. ***" ".
In
the last part of the sort, it puts it in alpha order, " "Labor ***",
"Misc.
***", "Parts ***" ".

I have tried choosing "special" at all the levels, but still no sucess.
--
David


"Bob Phillips" wrote:

Do the special sort on the other two columns, then do another sort on
the
column with the specific list.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David" wrote in message
...
Hi Group,
I have a spread sheet which I am sorting by 3 levels, all of which are
ascending. The last level of sort is based on Options with a specific
list,
which is not alphabetical anymore, but it does not seen to work and
puts
it
in alpha order anyway. Are "special" sort orders only good for the
first
level of sort?

--
David

3 level sort, last special order
 

Thanks. I did it a little differently than you suggested, sort of the other
way around. I found a help area that spoke of sorting on 4 columns and it
worked. I did the special sort first then the separate regular sort. Seems to
have worked.

Thanks again.
--
David


"Bob Phillips" wrote:

What I mean is do one sort using the two non-special columns. Then do
another sort, this time only keyed on the special column.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David" wrote in message
...
Hi,
I am not sure what you mean. The first sort is by "W/O Num" with no
"special" order, the second sort is by "Customer", again with no special
order, then the last sort is by "Labor/Part/Misc", which is based on a
list
and is the special sort order, " "Labor ***", "Parts ***", "Misc. ***" ".
In
the last part of the sort, it puts it in alpha order, " "Labor ***",
"Misc.
***", "Parts ***" ".

I have tried choosing "special" at all the levels, but still no sucess.
--
David


"Bob Phillips" wrote:

Do the special sort on the other two columns, then do another sort on
the
column with the specific list.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David" wrote in message
...
Hi Group,
I have a spread sheet which I am sorting by 3 levels, all of which are
ascending. The last level of sort is based on Options with a specific
list,
which is not alphabetical anymore, but it does not seen to work and
puts
it
in alpha order anyway. Are "special" sort orders only good for the
first
level of sort?

--
David