use a help column, i.e. if the states are in B2:B51 insert a temporary help
column next to B, then in the adjacent cell in what is now C2 put

=ISNUMBER(MATCH(B2,{"AK";"AZ";"CA";"CO";"HI";"ID"; "MT";"NM";"NM";"NV";"OR";"WA";"WY"},0))

copy down as long as needed, then select the whole range you need to have
sorted, sort by column C descending and secondly by column B ascending,
remove the help column

--
Regards,

Peo Sjoblom

Portland, Oregon




"SeaTiger" wrote in message
m...
I need to sort my customer list with the states in my territory which
consist of CA, NV, AZ, HI, WA, AK, OR, CO, NM, ID, WY, NM, MT.

Thanks,
victor