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?
Row Labels Sum of Total GM YTD Sum of Total GM YTD3 0.90
99 331634 34
170985 33411 10.07%
171831 28372 18.63%
450926 26209 26.53%
173231 20268 32.64%
354535 15534 37.33%
172085 13506 41.40%
174976 11873 44.98%
169483 11496 48.45%
169325 10771 51.70%
170683 9833 54.66%
170950 9551 57.54%
171935 9502 60.41%
492485 9402 63.24%
169369 9366 66.06%
328111 7994 68.48%
169443 7321 70.68%
424411 6525 72.65%
173572 6249 74.53%
174670 4628 75.93%
169496 4271 77.22%
170663 4041 78.44%
485345 3627 79.53%
173862 3611 80.62%
174576 3499 81.67%
501702 3404 82.70%
171543 3330 83.70%
171765 3155 84.66%
486030 3102 85.59%
173525 3035 86.51%
170770 2210 87.17%
169387 2165 87.83%
171027 2161 88.48%
171947 2088 89.11%
170721 2078 89.73%
517685 2044 90.35%
341556 1870 90.91%
169903 1831 91.47%
171842 1804 92.01%
170060 1794 92.55%
357562 1693 93.06%
171707 1679 93.57%
367398 1576 94.04%
171875 1433 94.48%
325861 1428 94.91%
171237 1345 95.31%
169911 1330 95.71%
172316 1255 96.09%
172099 1202 96.45%
163620 1127 96.79%
169816 1087 97.12%
171279 1073 97.44%
172385 975 97.74%
172506 885 98.01%
430848 809 98.25%
330834 682 98.45%
225663 627 98.64%
172698 623 98.83%
338213 593 99.01%
174592 573 99.18%
173226 544 99.35%
174207 426 99.48%
508986 375 99.59%
357945 322 99.69%
172834 284 99.77%
492755 210 99.84%
174914 152 99.88%
426110 108 99.91%
170223 99 99.94%
438205 99 99.97%
506187 65 99.99%
173066 24 100.00%
509333 100.00%
169394 0 100.00%
174061 100.00%
422584 100.00%
462086 100.00%
173829 0 100.00%
174598 0 100.00%
408342 0 100.00%
172524 0 100.00%
Bookmarks