Spreadsheet: 863217d1710785109-trying-to-pull-together-info-from-pivot-with-if-countif-jos-workbook-3
Sheet: Pivot Data

RECRUITMENT
Changed / No Change | Changed
Count of Recruitment Status | Column Labels
Row Labels | B006 | B007 | B014 | B015 | B016 | B017 | B019 | B020 | B021 | B027 | B030 | B045 | B046 | B059 | B076 | B077 | B083 | B086 | B101 | B102 | B103 | B104 | B105 | B107 | B108 | B109 | B112 | B115 | B116 | B121 | B129 | B133 | B142 | B151 | B158 | B159 | B161 | B165 | B174 | B181 | B186 | B192 | B194 | B195 | B200 | B203 | B204 | B205 | B207 | B208 | B215 | B216 | B229 | B231 | B234 | B236 | B292 | B324 | B332 | B336 | B338 | B341 | B344 | B347 | B361 | Grand Total
1. Job Spec Required |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
10. In Post | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 |  |  | 1 |  | 1 |  |  |  | 1 | 1 | 1 |  |  |  | 1 | 1 |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 |  | 1 | 1 |  | 47
2. Sourcing |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 6
3. Shortlist |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
4. At Interview |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
7. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 7
8. Security Confirmed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
9. Start Date Agreed |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 3
Employee Left |  |  |  |  |  | 1 |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 | 1 |  |  |  |  |  |  |  | 1 |  | 1 | 17
Internal Move | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 |  |  |  |  | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 |  | 1 |  | 31
Role Removed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 6
Status Change |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 | 1 |  | 1 |  |  | 1 | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 11
Grand Total | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 136
ACCOMPANIMENT
Changed / No Change | Changed
Count of Accompaniment Status | Column Labels
Row Labels | B006 | B007 | B014 | B015 | B016 | B017 | B019 | B020 | B021 | B027 | B030 | B045 | B046 | B059 | B076 | B077 | B083 | B086 | B101 | B102 | B103 | B104 | B105 | B107 | B108 | B109 | B112 | B115 | B116 | B121 | B129 | B133 | B142 | B151 | B158 | B159 | B161 | B165 | B174 | B181 | B186 | B192 | B194 | B195 | B200 | B203 | B204 | B205 | B207 | B208 | B215 | B216 | B229 | B231 | B234 | B236 | B292 | B324 | B332 | B336 | B338 | B341 | B344 | B347 | B361 | Grand Total
0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 4
Family |  |  |  | 2 |  |  | 1 | 2 |  |  | 1 |  | 1 |  |  |  |  |  | 1 |  |  |  | 1 |  | 1 | 2 |  | 1 |  |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 21
Married |  |  | 1 |  |  | 1 |  |  | 2 | 1 |  | 1 |  |  | 1 | 1 | 1 |  |  |  |  | 1 |  |  | 1 |  | 1 |  | 1 |  | 1 |  |  | 1 | 2 | 2 |  | 1 | 1 | 1 |  | 1 |  |  | 2 | 1 | 1 | 1 |  | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  | 1 |  |  |  |  | 1 | 36
Single | 2 | 2 | 1 |  | 2 | 2 | 1 | 1 |  | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 2 | 2 | 1 | 1 | 2 | 1 |  |  | 1 | 1 | 2 |  | 2 |  | 1 |  |  | 2 | 1 | 1 | 1 | 2 | 1 | 2 | 2 |  |  |  |  | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 2 | 2 | 2 | 1 | 75
Grand Total | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 136
TEAM
Changed / No Change | Changed
Count of Team | Column Labels
Row Labels | B006 | B007 | B014 | B015 | B016 | B017 | B019 | B020 | B021 | B027 | B030 | B045 | B046 | B059 | B076 | B077 | B083 | B086 | B101 | B102 | B103 | B104 | B105 | B107 | B108 | B109 | B112 | B115 | B116 | B121 | B129 | B133 | B142 | B151 | B158 | B159 | B161 | B165 | B174 | B181 | B186 | B192 | B194 | B195 | B200 | B203 | B204 | B205 | B207 | B208 | B215 | B216 | B229 | B231 | B234 | B236 | B292 | B324 | B332 | B336 | B338 | B341 | B344 | B347 | B361 | Grand Total
Air Service |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
CAMSS |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 |  | 2 |  |  | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 21
Depth |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 |  |  | 2 | 2 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
Forward | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 3 | 2 | 2 |  |  |  | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  |  |  | 1 | 1 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
Manage Support |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2 | 2 | 2 |  |  | 2 | 3 |  |  |  |  | 2 | 15
SC&A |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 2 |  | 2 | 2 | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 17
Supply Chain |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 2 | 2 | 2 |  |  | 10
Training |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 2
Grand Total | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 136
GRADE
Changed / No Change | Changed
Count of Grade | Column Labels
Row Labels | B006 | B007 | B014 | B015 | B016 | B017 | B019 | B020 | B021 | B027 | B030 | B045 | B046 | B059 | B076 | B077 | B083 | B086 | B101 | B102 | B103 | B104 | B105 | B107 | B108 | B109 | B112 | B115 | B116 | B121 | B129 | B133 | B142 | B151 | B158 | B159 | B161 | B165 | B174 | B181 | B186 | B192 | B194 | B195 | B200 | B203 | B204 | B205 | B207 | B208 | B215 | B216 | B229 | B231 | B234 | B236 | B292 | B324 | B332 | B336 | B338 | B341 | B344 | B347 | B361 | Grand Total
GG06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
GG07 | 2 | 2 | 2 | 2 | 2 |  |  |  | 2 | 2 |  |  |  | 2 | 2 |  | 2 | 2 |  |  |  |  |  |  |  |  | 1 |  |  | 2 | 2 |  | 1 |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 1 |  | 33
GG08 |  |  |  |  |  | 3 | 2 | 3 |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2 | 2 | 2 | 2 | 3 | 2 | 1 | 2 | 2 |  |  | 2 | 1 |  | 3 | 2 | 2 |  |  |  | 2 | 2 | 2 | 2 |  |  |  | 2 | 2 | 3 | 2 |  | 2 |  | 2 |  | 2 |  |  | 1 | 2 |  | 2 |  |  | 68
GG09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 3
GG10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 2 |  |  |  |  |  |  |  | 2 | 2 |  |  |  |  |  |  | 2 |  | 2 |  | 2 | 2 | 1 |  |  |  |  |  | 21
GG11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2
GG12 |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Grand Total | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 136