Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
SeaTiger
 
Posts: n/a
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.newusers
Debra Dalgleish
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
MinutiaMinder
 
Posts: n/a
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.newusers
SeaTiger
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to sort data in worksheet by specific date joey Excel Discussion (Misc queries) 0 November 14th 05 08:59 PM
Can I make Excel sort and graph a list of numbers? Nivek Charts and Charting in Excel 5 October 27th 05 10:05 PM
How do I sort a list that contains blanks that I want to keep? SHexceluser Excel Discussion (Misc queries) 5 October 14th 05 10:27 PM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM
How do I sort a birthdate list by month then day regardless of ye. ejeff Excel Discussion (Misc queries) 1 December 11th 04 10:56 PM


All times are GMT +1. The time now is 04:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"