View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bishop Bishop is offline
external usenet poster
 
Posts: 208
Default 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?