How Can You Recover Samsung Tablet?: Solution to Error: Count how many patients saw more than one dept

Friday, September 23, 2016

Solution to Error: Count how many patients saw more than one dept

Count how many patients saw more than one dept

My data contains Unique IDs, Appt dates, Unit seen in
I need to count how many patients we have that use more than 1 service at the health center vs.
patients that use just 1 service
, I did a pivot table, but it only counts the number of times seen in a particular dept. For example, if someone was seen in Family Medicine 3 times and nowhere else, then I only want them to show family medicine once, if they've been seen in any other
departments, then the ID, and the number of depts they were seen in. Make sense?
i.e.
ID                  Dept
001               Family Medicine
001               Family Medicine
001               Urgent Care
048               Social Services
048               Social Services
048               Social Services
086               Urgent Care
086               Urgent Care
100               Family Medicine
100               Radiology
100               Urgent Care
100               Urgent Care
118               Mental Health
118               Mental Health

ID
Department
Total

0
FAMILY MEDICINE
2

URGENT CARE
1

48
SOCIAL SERVICES
3

86
URGENT CARE
2

100
FAMILY MEDICINE
1

RADIOLOGY
1

URGENT CARE
2

118
MENTAL HEALTH
2

130
FAMILY MEDICINE
1

MENTAL HEALTH
16

URGENT CARE
3

143
FAMILY MEDICINE
3

LABORATORY
1

RADIOLOGY
1

URGENT CARE
1

173
FAMILY MEDICINE
1

RADIOLOGY
1

URGENT CARE
2

Anwsers to the Problem Count how many patients saw more than one dept

Download Error Fixer (Free)

For the example with data in A1 to B15 Use Advanced Filter to create a unique list of the data and then use COUNTIFS function to count the number of occurrences against the original list.

Select Data A1:B15 (Include the column headers)
Select Data Ribbon -> Advanced Filter (In Sort & Filter Block)
Select Copy to another location
Click icon at end of Copy to field.
Select the first cell of where you want the output.
(For the example I used F1)
Click icon at end of field to return to previous dialog box.
Select Unique records only
Click OK
Unique records now in range F1:G9
In cell H2 enter the formula =COUNTIFS($A$2:$A$15,F2,$B$2:$B$15,G2)
Copy formula down.

To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Recommended Method to Fix the Problem: Count how many patients saw more than one dept:

How to Fix Count how many patients saw more than one dept with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will perform a scan for your system. The junk files will be shown in the list.