How to Sort Customer List with Specific States
 

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

How to Sort Customer List with Specific States
 

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

How to Sort Customer List with Specific States
 

Another option is to create a custom list, and use it as your sort order.

To create a custom list --
In a cell on a blank worksheet, type the list of states in your territory
Select the list of states
Choose ToolsOptions
Select the Custom Lists tab
Click the Import button, click OK

To sort the states in your customer list--
Select a cell in the states column, and choose DataSort
From the first dropdown, choose State
Click the Options button
From the 'First key sort order' dropdown, choose your list
Click OK, click OK

SeaTiger wrote:
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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

How to Sort Customer List with Specific States
 

If you don't already have the states in a separate column, you'll need to
create a new column just for the states. Then you can sort by that column.
In other words, if your customer list says:

Joe Blow 123 Main St. Denver, CO 80203

You'll need to add another column, like this:

Joe Blow 123 Main St. Denver, CO 80203 CO
--
www.minutiaminders.com

The Entrepreneur''s Lifeline


"SeaTiger" wrote:

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

How to Sort Customer List with Specific States
 

Thanks for all the suggestions. Actually, I think I came up with something
easier for me to work with. I used the advance filter function. I added
listed the states that I wanted to filter in specific rows above my ST
column.

Best regards,
victor

"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