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.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Count records exported from another system. [Solved],How to Resolve - corrupt install of bittorrent?,Count Cell Use in a Column,How Can You Fix - Copy Email Addresses from Excel to Distribution List?,Troubleshooter of Error: Copy of windows vista home premium does not have windows media center,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly

No comments:

Post a Comment