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?