 |
 | 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 / July 2007Sort
I need to sort a rather large data base. Coulmns are State, Customer, Product, Product Size etc. The entries currently are in order of invoice. I need to start by sorting by state, keeping all information together (State, customer ,product, product size etc.) just as it appeared in origional data base but now sorted by State vs Invoice. Thanks in advance Try this: Select the entire range of data, including the column headings (State, Customer, etc) From the Excel main menu: <Data><Sort> First "Sort By" dropdown should list the column headings (If it doesn't, Check: My list has: Header Row) Select: State from the list Check: Ascending (or descending) Click the [OK] button The list will sort by state and all corresponding data for each row will move accordingly. Does that help? *********** Regards, Ron XL2002, WinXP > I need to sort a rather large data base. Coulmns are State, Customer, > Product, Product Size etc. The entries currently are in order of invoice. [quoted text clipped - 4 lines] > > Thanks in advance 1) FWIW I have excell 2007 2) I highlight all cells, go to sort, custom sort, sort by state column = states sort alphabetically, nothing else sorts. I am doing something wrong. > Try this: > [quoted text clipped - 26 lines] > > > > Thanks in advance Hi Click on any cell in your table Insert tab>Table>OK Choose dropdown on State>Sort  SignatureRegards Roger Govier > 1) FWIW I have excell 2007 > 2) I highlight all cells, go to sort, custom sort, sort by state [quoted text clipped - 39 lines] >> > >> > Thanks in advance Clicked on cell, went to Insert, table, xpanded so all data I want to sort was included. Went to state-sort A-Z, 1st 3 colunms sorted correctly (state,customer,address). Product and $ volume columns did not move with the state/customer. I am still not doing something correctly. Thanks for your help and patience. > Hi > [quoted text clipped - 44 lines] > >> > > >> > Thanks in advance Hi Do you have an empty column between Address and Product? If all 5 columns are contiguous, then Insert>Table will include them all in the table range, and they will be sorted together. SignatureRegards Roger Govier > Clicked on cell, went to Insert, table, xpanded so all data I want to > sort [quoted text clipped - 59 lines] >> >> > >> >> > Thanks in advance No empty column between address & product > Hi > [quoted text clipped - 65 lines] > >> >> > > >> >> > Thanks in advance Hi Send me the file send to roger at technology4u dot co dot uk Do the obvious with dot's and at. SignatureRegards Roger Govier > No empty column between address & product > [quoted text clipped - 70 lines] >> >> >> > >> >> >> > Thanks in advance 1) I have Excel 2007 2) I had tried highlighting all cells, sorting > Try this: > [quoted text clipped - 26 lines] > > > > Thanks in advance
|
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.