LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
5string
 
Posts: n/a
Default sorting (alphabetizing) while keeping data in tact.

have xp prof and excel 2000. consider the following list:
smith, dale
1222 avondale st
anytown, usa 11111
656-245 5656
myers, ethel
jans, harvey
xerox corp
plays golf on wed
carter, andy

what i'd like to do is alphabetize the list by last name BUT, keeping the
info that goes with each name intact. when i try to do it, the program will
alphabetize the names but the personal information does't stay under each
name like it appears in the above list.

any help would be app.
tks
--
5string
 
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
Automatically sorting data leehutch Excel Discussion (Misc queries) 4 August 22nd 05 06:36 AM
Sorting data using roman numerals.... Hokie Bear Excel Discussion (Misc queries) 7 August 19th 05 10:05 PM
Keeping data without losing Formula's Inneed Excel Discussion (Misc queries) 3 August 17th 05 06:51 AM
Sorting Data that feeds into other formulas.... Kittine Excel Discussion (Misc queries) 1 July 26th 05 08:21 PM
Sorting Data from 2 sheets, one sheet which is already sorted M. S. Excel Worksheet Functions 0 July 15th 05 06:42 PM


All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"