Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting into Surname order (alphabetically ascending)
I am using Excel 97, I have a list of names in column A of
a worksheet like the following Julie Smith (Accounting) Albert George (Supplies) Fred Merrydale (Finance) I want to be able to sort them in alphabetical order with their surname in ascending order. To be even greedier it would be ideal if I could also sort them into departmental order. Can anyone please assist me with some code which could do these options for me? Thanks Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting by surname when first name and surname are in the same cel | New Users to Excel | |||
ascending sort definition [sorting alphabetically] | Excel Discussion (Misc queries) | |||
Sorting Data in ascending order | Excel Discussion (Misc queries) | |||
How do I # my rows in ascending order. | Excel Worksheet Functions | |||
sorting number in ascending order | Excel Discussion (Misc queries) |