Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting large worksheet | Excel Discussion (Misc queries) | |||
Sorting Master Worksheet to Regional Worksheet | Excel Worksheet Functions | |||
Worksheet sorting | Excel Discussion (Misc queries) | |||
sorting excel worksheet | Excel Worksheet Functions | |||
worksheet sorting | Excel Worksheet Functions |