Spreadsheet: 140674d1328859440-finding-common-ad-groups-in-a-list-813069-finding-common-ad-groups-jpw-sample-list
Sheet: List Sample

Staff ID | 1234567 | 2345678 | 3456789 | 45678901 | 56789012
Name | Smith | Jones | [NAME] | [NAME] | [NAME]
Business Unit | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Department | XX12 | XX12 | [NAME] | [NAME] | XX20
Level 4 ID | 40 | 40 | 40 | 40 | 40
Level 5 ID | 430 | 430 | 430 | 430 | 430
Level 6 ID | 431 | 431 | 431 | 431 | 431
Level 7 ID | 432 | 432 | 432 | 432 | 432
Level 8 ID | 57 | 57 | 57 | 57 | 57
GGC | 4 | 4 | 4 | 4 | 4
 | AD-GROUP-ALL | AD-GROUP-ALL | AD-GROUP-ALL | AD-GROUP-ALL | AD-GROUP-ALL
 | AD-COMPLIANCE-1 | AD-COMPLIANCE-20 | AD-FINANCE-03 | AD-FINANCE-16 | AD-FINANCE-16
 | AD-COMPLIANCE-2 | AD-COMPLIANCE-21 | AD-FINANCE-04 | AD-FINANCE-17 | AD-FINANCE-17
 | AD-COMPLIANCE-3 | AD-COMPLIANCE-22 | AD-FINANCE-05 | AD-FINANCE-18 | AD-FINANCE-18
 | AD-COMPLIANCE-4 | AD-COMPLIANCE-23 | AD-FINANCE-06 | AD-FINANCE-19 | AD-FINANCE-19
 | AD-COMPLIANCE-5 | AD-COMPLIANCE-24 | AD-FINANCE-07 | AD-COMPLIANCE-20 | AD-COMPLIANCE-20
 | AD-COMPLIANCE-6 | AD-COMPLIANCE-25 | AD-FINANCE-08 | AD-COMPLIANCE-21 | AD-COMPLIANCE-21
 | AD-COMPLIANCE-7 | AD-COMPLIANCE-26 | AD-FINANCE-09 | AD-COMPLIANCE-22 | AD-COMPLIANCE-22
 | AD-COMPLIANCE-8 | AD-COMPLIANCE-27 | AD-FINANCE-10 | AD-COMPLIANCE-23 | AD-COMPLIANCE-23
 | AD-COMPLIANCE-9 | AD-COMPLIANCE-28 | AD-FINANCE-11 | AD-COMP-07 | AD-COMP-07
 | AD-COMPLIANCE-10 | AD-COMPLIANCE-29 | AD-FINANCE-12 | AD-COMP-08 | AD-COMP-08
 | AD-COMPLIANCE-11 | AD-COMP-01 | AD-FINANCE-13 | AD-LEGAL-45 | AD-LEGAL-45
 | AD-COMPLIANCE-12 | AD-COMP-02 | AD-FINANCE-14 | AD-LEGAL-46 | AD-LEGAL-46
 | AD-COMPLIANCE-13 | AD-COMP-03 | AD-FINANCE-15 | AD-LEGAL-47 | AD-LEGAL-47
 | AD-COMPLIANCE-14 | AD-COMP-04 | AD-FINANCE-16 | AD-LEGAL-48 | AD-LEGAL-48
 | AD-COMPLIANCE-15 | AD-COMP-05 | AD-FINANCE-17 | AD-LEGAL-49 | AD-LEGAL-49
 | AD-COMPLIANCE-16 | AD-COMP-06 | AD-FINANCE-18 | AD-COMP-01 | AD-COMP-01
 | AD-COMPLIANCE-17 | AD-COMP-07 | AD-FINANCE-19 | AD-COMP-02 | AD-COMP-02
 | AD-COMPLIANCE-18 | AD-COMP-08 | AD-COMPLIANCE-20 | AD-COMP-03 | AD-COMP-03
 | AD-COMPLIANCE-19 | AD-COMP-09 | AD-COMPLIANCE-21 | AD-COMP-04 | AD-COMP-04
 | AD-COMPLIANCE-20 | AD-COMP-10 | AD-COMPLIANCE-22 | AD-COMP-05 | AD-COMP-05
 | AD-COMPLIANCE-21 | AD-COMP-11 | AD-COMPLIANCE-23 | AD-COMP-06 | AD-COMP-06
 | AD-COMPLIANCE-22 | AD-COMP-12 | AD-COMPLIANCE-24 | AD-HR-01 | AD-HR-01
 | AD-COMPLIANCE-23 | AD-COMP-13 | AD-COMPLIANCE-25 | AD-HR-02 | AD-HR-02
 | AD-COMPLIANCE-24 | AD-COMP-14 | AD-COMPLIANCE-26 | AD-HR-03 | AD-HR-03
 | AD-COMPLIANCE-25 | AD-COMP-15 | AD-COMPLIANCE-27 | AD-HR-04 | AD-HR-04
 | AD-COMP-28 | AD-COMP-16 | AD-COMPLIANCE-28 | AD-HR-05 | AD-HR-05
 | AD-COMP-29 | AD-COMP-17 | AD-COMPLIANCE-29 | AD-HR-06 | AD-HR-06
 | AD-COMP-30 | AD-COMP-18 | AD-COMP-07 | AD-HR-07 | AD-HR-07
 | AD-COMP-31 | AD-COMP-19 | AD-COMP-08 | AD-HR-08 | AD-HR-08
 | AD-LEGAL-46 | AD-COMP-20 | AD-LEGAL-45 | AD-HR-09 | AD-HR-09
 | AD-LEGAL-47 | AD-COMP-21 | AD-LEGAL-46 | AD-HR-10 | AD-HR-10
 |  | AD-COMP-22 | AD-LEGAL-47 | AD-HR-11 | AD-HR-11
 |  | AD-COMP-23 | AD-LEGAL-48 | AD-HR-12 | AD-HR-12
 |  | AD-COMP-24 | AD-LEGAL-49 | AD-HR-13 | AD-HR-13
 |  | AD-COMP-25 |  | AD-HR-14 | AD-HR-14
 |  | AD-COMP-26 |  |  | AD-COMPLIANCE-24
 |  | AD-COMP-27 |  |  | AD-COMPLIANCE-25
 |  | AD-COMP-28 |  |  | AD-COMPLIANCE-26
 |  | AD-COMP-29 |  |  | AD-COMPLIANCE-27
 |  | AD-COMP-30 |  |  | AD-COMPLIANCE-28
 |  | AD-COMP-31 |  |  | AD-COMPLIANCE-29
 |  | AD-COMP-32 |  |  | AD-OTHER-01
 |  | AD-COMP-33 |  |  | AD-OTHER-02
 |  | AD-COMP-34 |  |  | AD-OTHER1-03
 |  | AD-COMP-35 |  |  | AD-OTHER1-04
 |  | AD-COMP-36 |  |  | AD-OTHER1-05
 |  | AD-COMP-37 |  |  | AD-OTHER1-06
 |  | AD-COMP-38 |  |  | AD-OTHER1-07
 |  | AD-COMP-39 |  |  | AD-OTHER2-08
 |  | AD-COMP-40 |  |  | AD-OTHER2-09
 |  | AD-COMP-41 |  |  | AD-OTHER2-10
 |  | AD-COMP-42 |  |  | AD-OTHER2-11
 |  | AD-COMP-43 |  |  | AD-OTHER2-12
 |  | AD-COMP-44 |  |  | AD-OTHER-13
 |  | AD-COMP-45 |  |  | AD-OTHER-14
 |  | AD-COMP-46 |  |  | AD-OTHER-15
 |  | AD-COMP-47 |  |  | AD-OTHER-16
 |  | AD-COMP-48 |  |  | AD-OTHER-17
 |  |  |  |  | AD-OTHER-18
 |  |  |  |  | AD-OTHER-19
 |  |  |  |  | AD-OTHER-20
 |  |  |  |  | AD-OTHER-21
 |  |  |  |  | AD-OTHER-22
 |  |  |  |  | AD-OTHER-23
 |  |  |  |  | AD-OTHER-24
 |  |  |  |  | AD-OTHER-25
 |  |  |  |  | AD-OTHER-26
 |  |  |  |  | AD-OTHER-27
 |  |  |  |  | AD-OTHER-28
 |  |  |  |  | AD-OTHER-29
 |  |  |  |  | AD-OTHER-30
 |  |  |  |  | AD-OTHER-31
 |  |  |  |  | AD-OTHER-32
 |  |  |  |  | AD-OTHER-33
 |  |  |  |  | AD-OTHER-34
 |  |  |  |  | AD-OTHER-35
 |  |  |  |  | AD-OTHER-36
 |  |  |  |  | AD-OTHER-37
 |  |  |  |  | AD-OTHER-38
 |  |  |  |  | AD-OTHER-39
 |  |  |  |  | AD-OTHER-40
 |  |  |  |  | AD-OTHER-41
 |  |  |  |  | AD-OTHER-42