ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can a sort be set up to run within another sort? (https://www.excelbanter.com/excel-worksheet-functions/188576-can-sort-set-up-run-within-another-sort.html)

worker bee

Can 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


Pete_UK

Can a sort be set up to run within another sort?
 
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
wrote:
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




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com