 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2004sorting in excel
how do i sort addresses in excel. i have saved the addresses in thre rows. for example *_address_______|______details_______________ * ----------------|---------------------- aaaaa | fdskfh sdkjsfk aaaaa | hsdjahdjk aaaaa | --------------------------------------- bbbbb | hjjkhuhjkhlkj bbbbb | hkjhjjjhjkk bbbbb | where a and b are two different addresse Hi I'm afraid you have to redesign your sheet - unless you'll write a VBA script which does sorting. My advice is to use design: Address, Detail1, Detail2, ... i.e. a row for every address.  SignatureArvi Laanemets (When sending e-mail, use address arvil<At>tarkon.ee) > how do i sort addresses in excel. i have saved the addresses in three > rows. for example [quoted text clipped - 11 lines] > > where a and b are two different addresses Looks like they're sorted to me... All aaaaa first then bbbbb next ... Could you clarify your question? You may select Data|Sort from the menu and select first sort order as address then secondly by details.... > how do i sort addresses in excel. i have saved the addresses in three > rows. for example [quoted text clipped - 11 lines] > > where a and b are two different addresses |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.