How to arrange in ascending order all subtotals

Dear All,

I have a sales commission file , where there are columns of invoices number , date , amount of invoices , sales executive code .

the problem is each invoice would be for one sales executive only and not for any other sales executive .

but in my invoice number (12345) is appearing for eg: in sales executive code( 4 ) also and (10) also .

there are many case like this . i want to sort out how can i find out that all invoices will be in there sales executive code only .

It's a bit difficult to visualize your issue based on your sample file when your sample file contains none of this

my invoice number (12345) is appearing for eg: in sales executive code( 4 ) also and (10) also .

We would love to help you with your question, but 1st, please rename your thread to something more meaningful, that actually describes your problem. Many members will look at a thread title, and if it is of interest to them, or falls within their area of expertese, they might only open those threads. also, searching for "help" will not turn up too many results that will benifit you, sorry.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

Hi is anybody there to help me with excel filr .


I have subtotal all invoices amount as per sales code, now i want to arrange in ascending order each sales man wise . I know how to do arrange ascending , but this case i want to do with each sales man wise only.

I have edited the title of the 1st post. You should do the same in future. Thanks.