Spreadsheet: 44800d1243540866-need-help-filtering-a-list-in-a-new-worksheet-from-a-master-list-personnel-tracker-mock
Sheet: Master

Current Manager | Name | Contractor/ Employee ID | Logon ID | Purchasing Test Score | Suspense Test Score
MICK | [NAME] | C11111 | asdfhjkl1 | N/A | N/A
CHRIS | Sergiel P | C11112 | asdfhjkl2 | N/A | N/A
CHRIS | [NAME] | C11113 | asdfhjkl3 | N/A | N/A
CHRIS | [NAME] | C11114 | asdfhjkl4 | N/A | N/A
CHRIS | Penny P | [NAME] | asdfhjkl5 | N/A | N/A
CHRIS | Rita V | C11116 | asdfhjkl6 | N/A | 0.8625
CHRIS | Vahe B | C11117 | asdfhjkl7 | N/A | 0.9221
MICK | Glenda R | C11118 | asdfhjkl8 | N/A | 1
CHRIS | [NAME] | C11119 | asdfhjkl9 | N/A | 0.964
CHRIS | [NAME] | C11120 | asdfhjkl10 | N/A | 0.8961
CHRIS | Adrian A | C11121 | asdfhjkl11 | 0.9052 | 0.9625
CHRIS | Antoine A | C11122 | asdfhjkl12 | 0.977 | 1
MICK | [NAME] | C11123 | asdfhjkl13 | 0.9713 | 0.9875
CHRIS | [NAME] | C11124 | asdfhjkl14 | 0.9425 | 0.975
CHRIS | [NAME] | C11125 | asdfhjkl15 | 0.9368 | 0.975
CHRIS | [NAME] | C11126 | asdfhjkl16 | 0.9598 | 0.9875
CHRIS | [NAME] | C11127 | asdfhjkl17 | 0.8621 | 0.9625
MICK | [NAME] | C11128 | [NAME] | 0.9713 | 0.975
CHRIS | Noah K | C11129 | asdfhjkl19 | 0.9253 | 0.9875
CHRIS | [NAME] | C11130 | asdfhjkl20 | 0.8621 | 0.9875
CHRIS | Sandro P | C11131 | asdfhjkl21 | 1 | 0.975
CHRIS | Serjik M | C11132 | [NAME] | 0.931 | 0.975
TRACY | Sandra L | C11133 | asdfhjkl23 | N/A | N/A
TRACY | [NAME] | C11134 | asdfhjkl24 | N/A | N/A
TRACY | [NAME] | C11135 | [NAME] | N/A | N/A
TRACY | [NAME] | C11136 | asdfhjkl26 | N/A | N/A
TRACY | [NAME] | C11137 | [NAME] | N/A | N/A
MICK | Fairy B | [NAME] | asdfhjkl28 | N/A | N/A
TRACY | [NAME] | C11139 | asdfhjkl29 | N/A | N/A
TRACY | [NAME] | C11140 | asdfhjkl30 | N/A | N/A
TRACY | [NAME] R | C11141 | asdfhjkl31 | N/A | N/A
TRACY | [NAME] | C11142 | asdfhjkl32 | N/A | N/A
MICK | [NAME] | C11143 | asdfhjkl33 | N/A | N/A
TRACY | Gengkok O | C11144 | asdfhjkl34 | N/A | N/A
TRACY | Maybel H | C11145 | [NAME] | N/A | N/A
TRACY | [NAME] | C11146 | asdfhjkl36 | N/A | N/A
MICK | Nadia P | C11147 | asdfhjkl37 | N/A | N/A
TRACY | Jennifer A | C11148 | asdfhjkl38 | N/A | N/A
TRACY | Monique R | C11149 | asdfhjkl39 | 0.9507 | 0.9459
TRACY | [NAME] | C11150 | asdfhjkl40 | 1 | 1
MICK | [NAME] R | C11151 | asdfhjkl41 | 0.9933 | 0.8529
TRACY | [NAME] | C11152 | asdfhjkl42 | 0.9733 | 0.9235
TRACY | [NAME] | C11153 | asdfhjkl43 | 0.9467 | 0.8716
TRACY | [NAME] | C11154 | [NAME] | 0.9648 | 0.9459
MICK | [NAME] | C11155 | asdfhjkl45 | 0.94 | 0.8529
TRACY | [NAME] | C11156 | asdfhjkl46 | 0.92 | 0.8941
TRACY | Twinky T | C11157 | asdfhjkl47 | 0.9333 | 0.8941
MICK | Candace R | C11158 | asdfhjkl48 | 0.9533 | 0.8581
TRACY | Heather H | C11159 | asdfhjkl49 | 0.9333 | 0.831
TRACY | Oganes K | C11160 | asdfhjkl50 | 0.96 | 0.9595
TRACY | [NAME] | C11161 | asdfhjkl51 | 0.9867 | 0.973
MICK | [NAME] | [NAME] | asdfhjkl52 | 0.96 | 0.9595
TRACY | [NAME] | [NAME] | asdfhjkl53 | 0.9933 | 0.8986
TRACY | [NAME] | C11164 | asdfhjkl54 | 0.9333 | 0.9189
TRACY | [NAME] | C11165 | asdfhjkl55 | N/A | 0.9875
MICK | [NAME] | C11166 | asdfhjkl56 | N/A | 0.9481
TRACY | [NAME] | C11167 | [NAME] | 0.96 | 1
TRACY | Rebecca T | C11168 | asdfhjkl58 | 0.9733 | 1
TRACY | Antonioni P | C11169 | asdfhjkl59 | 0.8533 | 0.975
MICK | [NAME] | C11170 | asdfhjkl60 | 0.8667 | 0.9625
TRACY | Maureen M | C11171 | asdfhjkl61 | 0.9 | 1
TRACY | [NAME] | C11172 | asdfhjkl62 | 0.86 | 0.9625
TRACY | Rogers A | C11173 | asdfhjkl63 | 0.8333 | 0.9625
TRACY | [NAME] | C11174 | asdfhjkl64 | 0.8067 | 1
MICK | [NAME] B | C11175 | asdfhjkl65 | 0.96 | 1
TRACY | Hank W | C11176 | asdfhjkl66 | 0.9368 | 1
TRACY | [NAME] | C11177 | asdfhjkl67 | 0.9741 | 1
MICK | Nedezda K | C11178 | asdfhjkl68 | 0.9713 | 0.975
TRACY | Remigio M | C11179 | asdfhjkl69 | 0.9195 | 0.9
TRACY | Rina D | C11180 | asdfhjkl70 | 0.9885 | 0.9625
TRACY | [NAME] | C11181 | asdfhjkl71 | 0.9195 | 0.975
TRACY | [NAME] | C11182 | [NAME] | N/A | 0.8625
MICK | [NAME] | C11183 | [NAME] | N/A | 0.975