Chris Hoagland

Posts: n/a

sorting

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Maintaining cell reference after sorting	GRITS	Excel Discussion (Misc queries)	2	April 30th 23 07:42 PM
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . .	agc1234	Excel Discussion (Misc queries)	6	May 26th 05 08:02 PM
sorting number in ascending order	Janice Lee via OfficeKB.com	Excel Discussion (Misc queries)	2	April 8th 05 10:31 PM
SORTING question	Rebecca	New Users to Excel	3	February 24th 05 05:35 PM
Adding a KeyID column for sorting	Rebecca	New Users to Excel	3	February 20th 05 07:09 PM

All times are GMT +1. The time now is 07:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us