Spreadsheet: 795435d1662675415-unique-tracking-by-category-without-overlap-certs_by_category_no_overlap-philchi-
Sheet: Summary

 |  |  |  |  | Adobe Analytics |  | Required | Current |  |  |  |  |  | Adobe Target |  | Required | Current
 |  |  |  |  | Business Practitioner |  | 6 | 4 |  |  |  |  |  | Business Practitioner |  | 6 | 9
 |  |  | EXPECTED RESULT |  | Developer |  | 3 | 2 |  |  |  | EXPECTED RESULT |  | Developer |  | 0 | NA
 |  |  |  |  | Architect |  | 1 | 1 |  |  |  |  |  | Architect |  | 4 | 4
 |  |  |  |  | Sales |  | 2 |  |  |  |  |  |  | Sales |  | 2
 |  |  |  |  | Example #1 - Missing Certs in Category |  |  |  |  |  |  |  |  | Example #2 - Meeting all certs; overage in a few
FILTER LIST FROM TABLE FOR THIS PRODUCT |  |  |  |  |  |  |  |  |  |  |  | FILTER LIST FROM TABLE FOR THIS PRODUCT
Product | Resources | Certification |  |  |  | Count | Required | True Result |  |  |  | Product | Resources | Certification |  |  | Actual | Target | True Results
Adobe Analytics |  | Business Practitioner |  |  | Developer |  | 3 | 2 | [NAME] and [NAME] only |  |  | Adobe Target |  | Business Practitioner |  | Business Practitioner |  | 6 | 6 | Allen, Elsi, Meta, Mariette, [NAME],[NAME], [NAME]
 | [NAME] | Developer |  |  | Business Practitioner |  | 6 | 4 | Jamison, [NAME], Traci, [NAME], Kleon - need 2 more |  |  |  | Frannie MacCurlye | Architect |  | Architect |  | 4 | 4 | Tris, Nil, Cathie, Frannie
 | Jamison Bandey | Architect |  |  | Architect |  | 1 | 1 | Wit |  |  |  | [NAME] | Business Practitioner |  | Developer |  | 0 | NA
 | Jamison Bandey | Business Practitioner |  |  |  |  |  |  | <<--- "13" is incorrect because some resources |  |  |  | [NAME] | Business Practitioner |  |  |  |  |  | <<-- A straight count incorrectly shows 16 but the actual number is 10
 | Jamison Bandey | Developer |  |  |  |  |  |  | have multiple certifications but can only be |  |  |  | [NAME] | Business Practitioner |  |  |  |  |  | Important!! - Since Frannie has both an Architect and BP certification, she was
 | [NAME] | Architect |  |  |  |  |  |  | counted once.  The correct math is 7 eligible |  |  |  | [NAME] | Architect |  |  |  |  |  | applied to the Architect category instead of the BP - otherwise, it would
 | [NAME] | Business Practitioner |  |  |  |  |  |  | certs and we are 3 certifications short |  |  |  | [NAME] | Business Practitioner |  |  |  |  |  | appear as though we didn't have enough certifications.  Is this business
 | [NAME] | Developer |  |  |  |  |  |  |  |  |  |  | Elsi Rhead | Business Practitioner |  |  |  |  |  | level logic possible via Excel formulas?
 | [NAME] | Business Practitioner |  |  | BUSINESS RULES |  |  |  |  |  |  |  | [NAME] | Architect
 | [NAME] | Developer |  | 1 | Cannot have a person's certifications applied to multiple categories, even if that person holds multiple |  |  |  |  |  |  |  | Nil Semmence | Architect
 | Traci Jerrans | Architect |  |  | certifications.  For example, [NAME] holds all 3 certifications but she can only be counted once for Specialization purposes. |  |  |  |  |  |  |  | Frannie MacCurlye | Business Practitioner
 | Traci Jerrans | Business Practitioner |  | 2 | The Required certification changes per product solution so the Developer, Architect or even the total numbers |  |  |  |  |  |  |  | [NAME] | Architect
 | [NAME] | Architect |  |  | may not be the same |  |  |  |  |  |  |  | [NAME] | Business Practitioner
 |  |  |  | 3 | The Total of the Required Column represents the minimum number of individuals needed to reach specialization
 | Unique Names from Above |  |  | 4 | Ignore the Sales row, it uses a separate formula and is solved
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Unique Names
 | Jamison Bandey
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Frannie MacCurlye
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Traci Jerrans |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Elsi Rhead
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Nil Semmence
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]