Spreadsheet: 713340d1610653113-need-help-with-counting-data-with-multiple-criteria-when-one-criteria-has-duplicates-report-for-help
Sheet: Data

Employee | Department | Course Title | Course Category
1 | Financial Counseling | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
1 | Financial Counseling | CAD SCHEDULING | Scheduling
1 | Financial Counseling | Epic Registration Only for Financial Counselors | Registration
1 | Financial Counseling | CAD SCHEDULING | Scheduling
1 | Financial Counseling | 2020 [NAME] | Registration
1 | Financial Counseling | Grand Central November 2020 Upgrade | Admissions
1 | Financial Counseling | CAD SCHEDULING | Scheduling
1 | Financial Counseling | 2010 Epic Updates | [NAME] Upgrade
2 | Emergency Registration | Emergency Department | Admissions
2 | Emergency Registration | CAD SCHEDULING | Scheduling
2 | Emergency Registration | COB/FO | Registration
2 | Emergency Registration | CAD SCHEDULING | Scheduling
2 | Emergency Registration | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
2 | Emergency Registration | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
2 | Emergency Registration | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
2 | Emergency Registration | 2020 [NAME] | Registration
2 | Emergency Registration | ADT PAR ADMISSION | Admissions
2 | Emergency Registration | 2010 Epic Updates | [NAME] Upgrade
3 | Health Information Management | 2010 Epic Updates | [NAME] Upgrade
3 | Health Information Management | Epic HIM for ROI Staff | HIM
4 | Financial Counseling | COB/FO | Registration
4 | Financial Counseling | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
4 | Financial Counseling | CAD SCHEDULING | Scheduling
4 | Financial Counseling | 2020 [NAME] | Registration
4 | Financial Counseling | Grand Central November 2020 Upgrade | Admissions
5 | Coding Department | 2010 Epic Updates | [NAME] Upgrade
5 | Coding Department | HIM OTHER | HIM
5 | Coding Department | 2018 Epic HIM Upgrade Training | [NAME] Upgrade
5 | Coding Department | 2018 Epic HIM Upgrade Training - Coders Only | [NAME] Upgrade
5 | Coding Department | HIM November 2020 Upgrade | Post 2019 Epic Upgrade
6 | Health Information Management | 2010 Epic Updates | [NAME] Upgrade
6 | Health Information Management | 2010 Epic Updates | [NAME] Upgrade
6 | Health Information Management | 2018 Epic HIM Upgrade Training | [NAME] Upgrade
7 | Financial Counseling | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
7 | Financial Counseling | 2018 Epic ADT Financial Counselors Only | Registration
7 | Financial Counseling | [NAME] 2019 ED Reg ADT PARs | Post 2019 Epic Upgrade
7 | Financial Counseling | 2020 [NAME] | Registration
7 | Financial Counseling | 2010 Epic Updates | [NAME] Upgrade
7 | Financial Counseling | COB/FO | Registration
7 | Financial Counseling | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
7 | Financial Counseling | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
7 | Financial Counseling | CAD SCHEDULING | Scheduling
7 | Financial Counseling | CAD SCHEDULING | Scheduling
7 | Financial Counseling | Epic Registration Only for Financial Counselors | Registration
7 | Financial Counseling | CAD SCHEDULING | Scheduling
7 | Financial Counseling | 2020 [NAME] | Registration
7 | Financial Counseling | Grand Central November 2020 Upgrade | Admissions
8 | Coding Department | 2010 Epic Updates | [NAME] Upgrade
8 | Coding Department | 2018 Epic HIM Upgrade Training - Coders Only | [NAME] Upgrade
9 | Revenue Integrity | Employee WC Instruction Directive | Registration
10 | Coding Department | Employee WC Instruction Directive | Registration
10 | Coding Department | 2010 Epic Updates | [NAME] Upgrade
10 | Coding Department | 2018 Epic HIM Upgrade Training - Coders Only | [NAME] Upgrade
11 | Eligibility Department | COB/FO | Registration
11 | Eligibility Department | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
11 | Eligibility Department | COB/FO | Registration
11 | Eligibility Department | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
12 | Financial Counseling | 2010 Epic Updates | [NAME] Upgrade
12 | Financial Counseling | COB and [NAME] | Registration
12 | Financial Counseling | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
12 | Financial Counseling | [NAME] 2019 ED Reg ADT PARs | Post 2019 Epic Upgrade
12 | Financial Counseling | 2020 [NAME] | Registration
12 | Financial Counseling | COB/FO | Registration
12 | Financial Counseling | Cash Drawer | Registration
12 | Financial Counseling | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
12 | Financial Counseling | 2020 [NAME] | Registration
13 | Eligibility Department | 2010 Epic Updates | [NAME] Upgrade
13 | Eligibility Department | CAD SCHEDULING | Scheduling
13 | Eligibility Department | EPIC HB Resolute Hospital Billing | HB
13 | Eligibility Department | 2020 [NAME] | Registration
14 | Financial Counseling | CAD SCHEDULING | Scheduling
14 | Financial Counseling | 2018 Epic Upgrade Grand Central (ADT) | [NAME] Upgrade
14 | Financial Counseling | [NAME] 2019 ED Reg ADT PARs | Post 2019 Epic Upgrade
14 | Financial Counseling | 2020 [NAME] | Registration
14 | Financial Counseling | 2010 Epic Updates | [NAME] Upgrade
14 | Financial Counseling | COB/FO | Registration
14 | Financial Counseling | 2016 Annual Medicare Secondary Payer Questionnaire | Registration
14 | Financial Counseling | CAD SCHEDULING | Scheduling
14 | Financial Counseling | 2020 [NAME] | Registration
14 | Financial Counseling | Grand Central November 2020 Upgrade | Admissions
15 | Patient Financial Services | 2010 Epic Updates | [NAME] Upgrade
15 | Patient Financial Services | HB FOR FOLLOW UP | HB
15 | Patient Financial Services | HB FOR CUSTOMER SERVICE | HB
15 | Patient Financial Services | RHB002 Resolute Hospital Billing Revenue Cycle | HB
15 | Patient Financial Services | RHB002 Resolute Hospital Billing Revenue Cycle | HB
15 | Patient Financial Services | RHB005 Overview of Claim Edit Workqueues | HB
15 | Patient Financial Services | RHB008 Viewing Account Maintenance | HB
15 | Patient Financial Services | RHB011 The Life of a Charge Part 1 | HB
15 | Patient Financial Services | RHB040 Managing Insurance Follow-Up | HB
15 | Patient Financial Services | RHB070 Self-Pay Follow-Up | HB