I asked this before but still have not received a reply. So maybe I didn't
explain it very well. I have a weekly spreadsheet with, say, 10 people on
it. For each of these people I have between 20 and 300 sales transactions.
So I have between 200 and 3000 rows of transactions for any given week. I
only need to see the top 5 highest value transactions from each rep. Is
there a way to filter out all but those 5 transactions for each rep? So in
the end I have 50 transactions and I want it to look like this:

Steve $240
Steve $210
Steve $140
Steve $95
Steve $20
Mary $234
Mary $230
Mary $224
Mary $134
Mary $34
John $456
John $455
John $446
John $356
John $56
..
..
etc.