Top 5 customers
 

hello,

I am trying to create a macro which will keep the top
five customers based on sales dollars for every sales rep
and delete all other customers within the sales rep. An
example of the spreadsheet is as follows:

Sales Rep Customer Sales Dollars
11111 222222 1000
11111 333333 500
11111 444444 500
11111 555555 300
11111 666666 250
11111 777777 100
22222 333333 700
22222 444444 500

Does anybody have any suggestions? Any assistance is
appreciated. Thank you.