Sorting a worksheet with weird conditions
 

I have a worksheet that I would like to do an untraditional sort. Col. L
contains the Status of each product, Col. M contains each products ship date,
Col. A contains each products Item #. Each cell in Col.L may contain one of
these words: "Archive", "Ready", "Complete", "On Time", "Late", or "". I
want to sort in this order:

Sort Col. L: "Archive", "Ready", "Complete", "On Time", "Late", then ""
Sort Col. M: xlAscending
Sort Col. A: xlAscending

How can I do this? I was thinking I may a need a hidden helper column next
to Col.L which would help with this sort, but was wondering if there is
another way.

How is the OrderCustom arguement used in Sort? The help section is very
vague.

Thanks in Advance!
--
Cheers,
Ryan

Sorting a worksheet with weird conditions
 

Add this formula to an auxilary column, copy formula down the new column, and
then sort on the new column instead of L

=MATCH(L1,{"Archive","Ready","Complete","On Time","Late"},0)

"RyanH" wrote:

I have a worksheet that I would like to do an untraditional sort. Col. L
contains the Status of each product, Col. M contains each products ship date,
Col. A contains each products Item #. Each cell in Col.L may contain one of
these words: "Archive", "Ready", "Complete", "On Time", "Late", or "". I
want to sort in this order:

Sort Col. L: "Archive", "Ready", "Complete", "On Time", "Late", then ""
Sort Col. M: xlAscending
Sort Col. A: xlAscending

How can I do this? I was thinking I may a need a hidden helper column next
to Col.L which would help with this sort, but was wondering if there is
another way.

How is the OrderCustom arguement used in Sort? The help section is very
vague.

Thanks in Advance!
--
Cheers,
Ryan

Sorting a worksheet with weird conditions
 

I assumed I would have to do that.

Are you fimilar what the OrderCustom arguement in the Sort method?
--
Cheers,
Ryan


"Joel" wrote:

Add this formula to an auxilary column, copy formula down the new column, and
then sort on the new column instead of L

=MATCH(L1,{"Archive","Ready","Complete","On Time","Late"},0)

"RyanH" wrote:

I have a worksheet that I would like to do an untraditional sort. Col. L
contains the Status of each product, Col. M contains each products ship date,
Col. A contains each products Item #. Each cell in Col.L may contain one of
these words: "Archive", "Ready", "Complete", "On Time", "Late", or "". I
want to sort in this order:

Sort Col. L: "Archive", "Ready", "Complete", "On Time", "Late", then ""
Sort Col. M: xlAscending
Sort Col. A: xlAscending

How can I do this? I was thinking I may a need a hidden helper column next
to Col.L which would help with this sort, but was wondering if there is
another way.

How is the OrderCustom arguement used in Sort? The help section is very
vague.

Thanks in Advance!
--
Cheers,
Ryan