Excel: Drop Down Help


Hi All I have a spreadsheet below. Its in a team ID order and also has Engineer Tech Numbers within. I want to create a drop down (ie) Team S0701-706 and once selected, return the whole teams results. Does anyone know the best forulas to use or point me in right direction?

TEAM TECH ID ENGINEER NAME COMP RFT ETA NFF ON D NPS CSAT
S0701 FS1338 STOTHER GARRY (SAT) 98.21% 96.43% 77.45% 50.70% 50.00% 90
S0701 FS3348 HALE DAVID (LAT) 93.71% 92.38% 79.31% 45.45% 36.49% 76.47% 94.5486
S0701 FS3962 EKWOANYA CHUKS 0.00% #N/A #N/A
S0701 FS4051 BUNN CHAS (LAT) (RR) 91.67% 83.33% 91.11% 46.15% 100.00% 100
S0701 FS4472 HAKIN DANIEL 95.00% 95.00% 79.07% 52.00% 0.00% 85
S0701 FS4540 COX EDWARD (LAT) (RR) 94.17% 94.17% 75.00% 0.00% 34.00% 100.00% 99.1667
S0701 FS4759 JALLOH ABDUL(LAT) 94.21% 91.46% 78.54% 33.33% 47.40% 60.71% 90.557
S0701 FS4819 GIBSON BEN (LAT) 92.94% 86.25% 78.29% 50.00% 52.13% 52.63% 91.0784
S0701 FS5665 BOSS RICKY 97.51% 94.70% 77.60% 66.67% 43.48% 50.00% 94.7286
S0701 0.00%
S0702 FS1361 TUERSLEY SAM (SAT) (RR) 92.59% 92.59% 83.33% 26.32% 100.00% 98.75
S0702 FS4285 SINCLAIR LEIGH (LAT) 0.00%
S0702 FS4474 HARRIS CHARLOTTE (LAT) 90.00% 89.17% 83.19% 50.00% 29.51% 60.00% 98
S0702 FS4484 COTTON-JONES BENJAMIN (RR) 88.16% 88.16% 100.00% 25.00% -33.33% 58.3333
S0702 FS4530 FITZGERALD LESLI(LAT) 93.26% 92.20% 83.23% 0.00% 46.11% 44.44% 93.4868
S0702 FS4935 KASOLI ISLAM (LAT) 92.24% 91.32% 81.36% 25.00% 39.61% 88.89% 96.6667
S0702 FS5579 SALLAH TARIQ (LAT) 91.67% 86.57% 83.13% 100.00% 36.17% 73.33% 93.0519
S0702 FS5656 HIRVING TAFARI (LAT) 91.84% 86.30% 62.33% 54.55% 59.69% 76.47% 98.5561
S0702 FS5677 HARPER SAM 85.07% 83.26% 71.55% 33.33% 50.89% 82.61% 95.9091
S0702 FS5712 PARMAR ALI 97.84% 92.81% 80.69% 41.67% 30.97% 81.82% 94.5455
S0702 FS5735 JOHNSON LUKE 0.00% 96.88% 0.00%
S0702 FS5774 POWELL KASSIM 0.00% #N/A #N/A
S0702 WL83 DANIEL FRANCIS (LAT) 91.51% 87.45% 84.06% 71.43% 42.86% 63.64% 92.0833
S0702 0.00% #N/A #N/A
S0703 FS1323 CUMMINGS DARREN (LAT) 94.94% 93.45% 78.13% 33.33% 49.74% 82.35% 87.2151
S0703 FS2021 WALLER NEIL (SAT) (RR) 92.22% 92.22% 66.67% 10.53% #N/A #N/A
S0703 FS2254 RICE PAUL (LAT) 95.37% 93.59% 79.43% 66.67% 48.18% 57.69% 88.5
S0703 FS2895 ARMSTON PAUL (SAT) (RR) 100.00% 100.00% 91.84% 100.00% 38.46% 0.00% 100
S0703 FS381 FORDHAM MARK (LAT) 92.28% 91.12% 71.65% 20.00% 46.94% 88.89% 97.3333
S0703 FS4486 BANJOKO ADEKUNLE 93.29% 91.16% 79.72% 41.67% 42.24% 57.58% 90.1273
S0703 FS5010 STRETTON SCOTT (LAT) 95.10% 93.01% 72.45% 50.00% 68.06% 66.67% 94
S0703 FS5046 MILLER SEAN (LAT) 92.40% 89.60% 88.57% 0.00% 54.61% 67.86% 95.4487
S0703 FS5084 REYNOLDS JASON (LAT) (LAT) 89.61% 84.95% 68.77% 50.00% 54.55% 68.75% 91.7949
S0703 FS5280 BISHOP DWAYNE (LAT) 86.26% 80.15% 60.29% 20.00% 54.81% 66.67% 83.3333
S0703 FS5615 PEARSON ELIOT (LAT) 93.20% 90.00% 74.56% 75.00% 38.93% 71.43% 92.3333
S0703 FS753 PEARSON JAMES (LAT) 95.22% 93.17% 57.79% 54.55% 55.07% 76.92% 93.1993
S0703 AP62 HAZAEL BYRON 0.00% #N/A #N/A
S0703 0.00% #N/A #N/A
S0704 CN52 TECLEHAIMANOT REZENE (LAT) 92.00% 88.00% 100.00% 100
S0704 FS3720 HOWARD CARL (LAT) (RR) 81.58% 78.95% 60.76% 66.67% 55.00% 66.67% 86.6667
S0704 FS5254 MALCOLM KEVIN (LAT) 92.70% 90.51% 84.55% 50.00% 37.23% 65.52% 86.7037
S0704 FS5331 JAMES THOMAS (LAT) (RR) 88.78% 82.93% 80.51% 33.33% 39.39% 92.86% 96.2143
S0704 FS5349 SKOREK TOMASZ (LAT) 91.18% 89.50% 93.15% 100.00% 40.82% 81.82% 94.1667
S0704 FS5446 KEY CRAIG (LAT) 89.05% 88.10% 65.74% 100.00% 29.17% 62.50% 95.4762
S0704 FS5452 ARUMUGATHASAN CHITHRANGHAN LAT 86.41% 84.95% 69.78% 50.00% 30.93% 66.67% 96.6667
S0704 FS5621 VASSELL ASHLEE (LAT) 85.67% 83.12% 84.04% 29.07% 68.75% 94.7619
S0704 FS5666 EVERITT GARY 89.83% 88.98% 85.40% 40.00% 32.89% 55.56% 89.0714
S0704 FS5667 MARSH DANIEL (LAT) 91.29% 88.38% 75.00% 50.00% 46.67% 70.00% 87.2321
S0704 FS5711 SIDDIQUI MUHAMMED 94.90% 91.84% 86.57% 60.00% 37.40% 62.50% 95.8333
S0704 FS5710 SETHI GAGANDEEP 85.96% 83.33% 70.95% 50.00% 70.00% 95.5556
S0704 0.00% #N/A #N/A
S0705 FS4546 BROWNSEA DANIEL (RR) 90.79% 89.47% 84.62% 100.00% 49.47% 80.00% 94.6667
S0705 FS4556 BLOOM BILLY (RR) 77.50% 75.00% 87.72% 64.29% 66.67% 100
S0705 FS5093 ALLEN DEREK (LAT) 90.35% 84.94% 78.97% 75.00% 53.15% 61.54% 91.7033
S0705 FS5276 DOUGGAN STUART (LAT) 89.02% 86.59% 33.33% 80
S0705 FS5332 THOMPSON JASON (LAT) 91.21% 89.58% 65.33% 87.50% 40.97% 71.43% 91.0354
S0705 FS5447 STEER CHARLES (LAT) 84.06% 82.61% 73.71% 25.00% 38.00% 93.75% 91.732
S0705 FS5659 TARUVINGA TARU 87.33% 85.67% 65.38% 50.00% 64.93% 100.00% 100
S0705 FS5668 COCKBURN ANDREW 90.72% 89.35% 90.46% 80.00% 50.00% 67.86% 94.9647
S0705 FS5670 AHEARN FRANCIS (LAT) 87.83% 86.09% 66.28% 0.00% 44.19% 77.78% 95.641
S0705 FS5739 SHEARING WILLIAM 0.00% 45.71% 60.00%
S0705 FS5740 ELKHOUMANI NABIL 0.00% 91.18% 58.33%
S0705 FS5741 JOHNS MATTHEW 0.00% 54.84% 66.67%
S0705 0.00% #N/A #N/A
S0706 FS4531 DOUGLAS-WRIGHT KIRK (LAT) (RR) 80.60% 80.60% 71.79% 100.00% 51.06% 66.67% 94.125
S0706 FS4542 COOPER ANDREW (LAT) (RR) 88.82% 87.50% 63.91% 66.67% 39.19% 70.83% 97.0066


This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of October 26, 2014.


For more resources for Microsoft Excel