Spreadsheet: 130078d1322057929-top-data-based-on-rank-sample_showdata
Sheet: Summary

 |  |  |  | select district: |  |  |  | select corresponding rep:
 |  |  | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | SE YTD NAR performance (Top 15 SEs) vs. Houston - Austin - San Antonio - Albuquerque
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  |  |  |  |  |  |  |  |  | P.C Rank | Name | Avg. NAR per week * |  |  |  |  | % to weekly NAR quota |  |  |  |  |  |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 |  | graphing
 |  |  |  |  |  |  |  |  |  | 1 | Christen Emmett*** | 830.8881395348837 |  |  |  |  | 4.154440697674419 |  |  |  |  | #N/A | Dallas - Shreveport | 4255.5 | 9202 | 16910.69 | 1387.5 | 993 | 668 | 2311.5 | 0 | 0 | 0 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 2 | [NAME] | 495.3153488372092 |  |  |  |  | 2.476576744186046 |  |  |  |  | 1 | Houston - Austin - San Antonio - Albuquerque | 671.75 | 560.08 | 930.86 | 1344.97 | 8626 | 1605.41 | 2244.32 | 1055.46 | 3195.16 | 1064.55 |  |  |  | 495.3153488372092
 |  |  |  |  |  |  |  |  |  | 3 | [NAME] | 423.4186046511628 |  |  |  |  | 2.117093023255814 |  |  |  |  | #N/A | Newark - White Plains | 220 | 1888 | 1815 | 1470 | 865 | 3081 | 2523 | 2168 | 2280 | 1897 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 4 | [NAME] | 406.4069767441861 |  |  |  |  | 2.032034883720931 |  |  |  |  | #N/A | Cleveland - Pittsburgh - Cincinnati | 227.5 | 3623 | 6477 | 1663 | 1527 | 877 | 590 | 875 | 579 | 1037 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 5 | [NAME] | 360.9716279069768 |  |  |  |  | 1.804858139534884 |  |  |  |  | #N/A | Vancouver - Kelowna | 1053 | 4174 | 2251 | 2055 | 1179 | 1067 | 1235 | 930 | 578 | 999.78 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 6 | [NAME] | 356.6790697674419 |  |  |  |  | 1.783395348837209 |  |  |  |  | #N/A | Wichita - Oklahoma City | 585 | 712 | 795 | 1089 | 2558 | 4222.2 | 1925 | 220 | 445 | 2786 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 7 | [NAME] | 307.3255813953488 |  |  |  |  | 1.536627906976744 |  |  |  |  | #N/A | Orlando - Tampa | 771 | 638 | 551 | 742 | 2432 | 3322 | 1410 | 868 | 476 | 2005 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 8 | [NAME] | 293.5581395348837 |  |  |  |  | 1.467790697674419 |  |  |  |  | #N/A | New York - Long Island | 405 | 627 | 831 | 1085 | 1548 | 1555 | 2820 | 960 | 1013 | 1779 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 9 | [NAME] | 291.6830232558139 |  |  |  |  | 1.45841511627907 |  |  |  |  | #N/A | Ottawa - Winnipeg | 1139.5 | 1714 | 959 | 604 | 516 | 1049 | 1402 | 2644 | 1268.87 | 1246 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 10 | [NAME] | 290.7374418604651 |  |  |  |  | 1.453687209302325 |  |  |  |  | #N/A | Calgary - Edmonton | 1207.5 | 1150.21 | 924 | 1085 | 2038 | 1807 | 1226 | 1050 | 967 | 1047 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 11 | [NAME] | 289.2790697674419 |  |  |  |  | 1.446395348837209 |  |  |  |  | #N/A | Calgary - Edmonton | 1255 | 1677 | 953 | 674 | 1040 | 1315 | 1010 | 130 | 750 | 3635 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 12 | [NAME] | 288.1279069767442 |  |  |  |  | 1.440639534883721 |  |  |  |  | #N/A | New Orleans - Jackson | 995 | 643 | 883 | 1044 | 3390.1 | 2089.4 | 973 | 1013 | 526 | 833 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 13 | [NAME] | 279.5511627906977 |  |  |  |  | 1.397755813953488 |  |  |  |  | #N/A | Calgary - Edmonton | 1070 | 817 | 1434 | 1013 | 821 | 1135.2 | 1941 | 1227 | 943.5 | 1619 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 14 | [NAME] | 273.9651162790698 |  |  |  |  | 1.369825581395349 |  |  |  |  | #N/A | Washington - Philadelphia | 1459 | 290 | 920.39 | 1966.3 | 1736 | 1159.03 | 589.86 | 1273.04 | 1577.38 | 809.5 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 15 | [NAME] | 273.2790697674419 |  |  |  |  | 1.366395348837209 |  |  |  |  | #N/A | Miami - Fort Myers | 668 | 822 | 1222 | 1062 | 731 | 1178 | 898 | 2406 | 1563 | 1201 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 16 | [NAME] | 263.4281395348837 |  |  |  |  | 1.317140697674419 |  |  |  |  | #N/A | Salt Lake City - Boise | 4283.5 | 313 | 249 | 430 | 538 | 983 | 1811 | 875 | 1264.91 | 580 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 17 | [NAME] | 254.3325581395349 |  |  |  |  | 1.271662790697675 |  |  |  |  | #N/A | New Orleans - Jackson | 686 | 1791 | 1066.2 | 693 | 480 | 935 | 1429 | 1529 | 1344 | 983.1 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 18 | [NAME] | 247.1767441860465 |  |  |  |  | 1.235883720930233 |  |  |  |  | #N/A | Dallas - Shreveport | 407 | 980 | 771 | 1308 | 967 | 1280 | 2003.7 | 924.9 | 941 | 1046 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 19 | [NAME] | 246.9302325581395 |  |  |  |  | 1.234651162790698 |  |  |  |  | #N/A | Montreal - Quebec City | 494 | 1122 | 1013 | 1286 | 1069 | 1095 | 836 | 1519 | 815 | 1369 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 20 | [NAME] | 244.9767441860465 |  |  |  |  | 1.224883720930233 |  |  |  |  | #N/A | Des Moines - Omaha - Sioux Falls | 194 | 397 | 543 | 501 | 567 | 733 | 577 | 2067 | 3729 | 1226 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 21 | [NAME] | 237.6279069767442 |  |  |  |  | 1.188139534883721 |  |  |  |  | #N/A | Nashville - Knoxville | 755 | 641 | 382 | 3340 | 658 | 1687.5 | 471 | 691 | 584.5 | 1008 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | 22 | [NAME] | 236.8023255813953 |  |  |  |  | 1.184011627906977 |  |  |  |  | #N/A | San Francisco - Concord | 789 | 776 | 741 | 716 | 408 | 125 | 650 | 519 | 387 | 5071.5 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | ^ I would like top 15 to remain static (do not change)
 |  |  |  |  |  |  |  |  |  | however, depending on the district I select from drop down down menu in cell G7, I want this table to list the remaining
 |  |  |  |  |  |  |  |  |  | sales ppl. For this district based on the rank
 |  |  |  |  |  |  |  |  |  | the sales rep for the district are in "calculation sheet", I have highlighted in yellow.
 |  |  |  |  |  |  |  |  |  | pls help!