Spreadsheet: 124341d1318343680-lookup-help-data-extraction-help-sample_lookup
Sheet: SE Summary

 |  |  | I would like to show only "sales exec" appear on this worksheet from the "G.S" sheet
 |  | Rank | Name | Position | Branch | District | Session 1 (Oct 3 - Oct 16) | Session 2 (Oct 17 - Oct 30) | Session 3 (Oct 31 - Nov 13) | Session 4 (Nov 14 - Nov 27) | Session 5 (Nov 28 - Dec 11) | Contest Total
 |  | 1 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 2 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 3 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 4 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 5 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 6 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 7 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 8 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 9 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 10 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 11 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 12 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 13 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 14 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 15 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 16 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 17 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 18 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 19 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 20 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 21 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 22 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 23 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 24 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 25 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 26 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 27 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 28 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 29 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 30 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 31 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 32 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 33 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 34 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 35 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 36 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 37 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 38 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 39 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 40 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 41 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 42 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 43 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 44 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 45 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 46 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 47 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 48 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 49 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 50 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 51 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 52 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 53 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 54 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 55 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 56 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 57 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 58 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 59 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 60 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 61 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 62 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 63 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 64 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 65 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 66 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 67 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 68 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 69 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 70 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 71 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 72 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 73 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 74 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 75 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 76 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 77 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 78 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 79 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 80 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 81 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 82 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 83 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 84 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 85 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 86 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 87 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 88 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 89 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 90 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 91 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 92 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 93 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 94 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 95 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 96 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 97 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 98 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 99 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 100 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 101 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 102 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 103 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 104 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 105 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 106 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 107 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 108 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 109 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 110 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 111 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 112 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 113 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 114 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 115 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 116 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 117 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 118 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 119 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 120 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 121 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 122 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 123 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 124 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 125 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 126 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 127 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 128 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 129 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 130 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 131 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 132 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 133 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 134 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 135 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 136 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 137 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 138 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 139 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 140 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 141 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 142 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 143 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 144 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 145 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 146 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 147 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  | 148 | Enter name | Select a position | Select a branch | District |  |  |  |  |  | 0
 |  |  |  |  |  | Total | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | * New customer is defined as new service location with no sales activity in the last 18 months