Determining how many customers make up 90% of a sales person's budget, for a list of 2000

I've a spreadsheet of every customer # and their revenue YTD for 2000+ sales people. I've been asked to figure out the number of customers, by salesperson, equals 90% of their revenue. I pivoted the data listing the revenue by customer # in descending order in the first column and a second column that shows the running total. I can do a countif statement to determine what I need to do, but don't want to do that 2000+ times....any ideas?

Please Login or Register  to view this content.