 |
 | 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 / Worksheet Functions / May 2008Can a sort be set up to run within another sort?
I am trying to set up about 4 sort levels, i.e. first sort: no to yes 2nd sort: alpha name 3rd sort: alpha broker 4th sort: type of account All sorts are alpha Highlight the data to be sorted (including header row if you have one), then sort the lower orders first - for example alpha name, alpha broker and type of account. With the data still highlighted, click on Data | Sort again and this time sort on the remaining higher level criteria (in this case no to yes). Hope this helps. Pete On May 22, 6:09 pm, worker bee <worker b...@discussions.microsoft.com> wrote: > I am trying to set up about 4 sort levels, i.e. > [quoted text clipped - 4 lines] > > All sorts are alpha |
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.