LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
newexceluser
 
Posts: n/a
Default Sort a list with uneven row information

I have created a list of business card contacts with a number of columns.
Each contact also contains up to four rows of information i.e. "Address"
information (two or three rows for street address; apt/suite number; city,
state and zip), "Phone" information (with two three rows for cell phone,
telephone, fax), etc. etc.
When I attempt to "Sort" by "Ascending Order" the uneven rows of information
become separated and are placed at the bottom of the list, making the list of
very little use.
I have attempted to use a blank row between the contacts and have used no
blank row but the end result is the same.
I think there is a way to do what I want to do but I have run out of options
for trial.
Any help would be greatly appreciated.
 
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
custom list does not sort gitttep Excel Worksheet Functions 4 August 10th 05 03:22 PM
Can I sort a list with more than three fields? Teres Excel Discussion (Misc queries) 4 July 30th 05 02:21 PM
How do I sort a list of dates in Excel by month and day? Caroline Excel Discussion (Misc queries) 3 June 10th 05 11:58 PM
Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . Dan W Excel Worksheet Functions 0 December 1st 04 03:53 PM
How can I sort an entire spreadsheet from a list prod sorter Excel Worksheet Functions 4 November 17th 04 03:43 AM


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

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"