Sorting a Worksheet
I have a spreadsheet with all the sales transactions for 10 different reps.
Each rep has between 50 and 150 transactions each. I want to sort the sheet so that each reps 5 highest transactions are at the top. So rows 1-5 has Bill's 5 highest transactions, rows 6-10 has Sally's 5 highest transactions, rows 11-15 has Tom's 5 highest transactions, etc. How can I do this? |
Sorting a Worksheet
Originally the data is arranged by rep. For example, first I copy 50
transactions for Bill and paste them to the spreadsheet then I copy 75 transactions for Sarah and paste them in the spreadsheet under Bill's transactions. So on and so forth. The transactions for each rep are in no particular order. "Ashish Mathur" wrote: Hi, How is the data arranged? -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Bishop" wrote in message ... I have a spreadsheet with all the sales transactions for 10 different reps. Each rep has between 50 and 150 transactions each. I want to sort the sheet so that each reps 5 highest transactions are at the top. So rows 1-5 has Bill's 5 highest transactions, rows 6-10 has Sally's 5 highest transactions, rows 11-15 has Tom's 5 highest transactions, etc. How can I do this? |
All times are GMT +1. The time now is 04:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com