Unfortunately, the custom options only work for the primary key.

If you wanted to then sort the list using the last character as a secondary
key, you could enter this formula in your cheater column, Right(B1,1). This
time, you would have to sort the table 4 times. Essentially, once you have it
sorted using the first character as a key (N,W,S,E), you would select the N's
section of the table (and your cheater column), sort the N's using the method
in my last post, and so on for the W's, S's and E's.


"Chris Hoagland" wrote:

i need to sort a column for addresses. i can get it to sort somewhat.

example

n 7 ave e
n 7 ave w
s 8 ave e
s 8 ave w
w 7 st s
e 7 st s
w 8 st n

i would like to sort them by n w s e
it puts them in n s but alphabetizes the w e ones

any help?