Sorting a Worksheet

  • Thread starter Thread starter Bishop
  • Start date Start date
B

Bishop

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?
 
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.
 
Back
Top