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
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 Tools>Options
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 Data>Sort
From the first dropdown, choose State
Click the Options button
From the 'First key sort order' dropdown, choose your list
Click OK, click OK
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:
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.