LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 196
Default 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
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
Sorting by surname when first name and surname are in the same cel Louise New Users to Excel 3 April 5th 23 02:50 PM
ascending sort definition [sorting alphabetically] GaryBlade Excel Discussion (Misc queries) 2 January 6th 10 02:42 AM
Sorting Data in ascending order sharon2006 Excel Discussion (Misc queries) 1 March 14th 06 01:07 AM
How do I # my rows in ascending order. burgos Excel Worksheet Functions 1 February 16th 06 07:13 PM
sorting number in ascending order Janice Lee via OfficeKB.com Excel Discussion (Misc queries) 2 April 8th 05 10:31 PM


All times are GMT +1. The time now is 11:48 AM.

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"