Number of times patient missed appointments - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

This is a practical application to determine number of times a patient missed appointment.   Count Number Of Time Patients Missed Appointments  =COUNTIFS($B$2:$B$69,B2,$C$2:$C$69,"NO")   Identify Patients Who Missed Appointment Twice  =IF(D2>=2,"Missed 2 Appt","")   countif, missed appointment, hospital appointment no show,appointment data,

Transcript

00:00One of our local medical office here wants me to help them identify patients who have

00:04missed two or more scheduled appointments. The first thing I'm going to do is to count

00:07the number of missed appointments on column D by each patient. I'm going to use a function

00:13called count ifs with a s because I'm going to use multiple criteria. The first argument

00:20will be the data set or the column for the patient name. I'm going to press F4 once to

00:24make it into a fix and then the second argument would be B2, the person or the name itself

00:30of the person and then comma. The second argument will be the attended column which is C all

00:36the way down and press F4 to make it fix again and then the fourth argument would be the text

00:42NO to indicate did not attend and I'm going to hit enter after that. As you can see Melvin

00:48has missed one appointment and if you double click this handle here you'll apply the rest

00:53of the rule. The next thing I'm going to do is basically flag which patients have missed

00:58two or more appointments. I'm going to use a simple if statement here open parenthesis this

01:04particular cell greater than equal to two. If you want to change this to three or four

01:11number of times that the patients have missed you can change it here. For this example I'm

01:14just going to say two and if this is true I'm going to display the text called missed two

01:20appointment like that. Double quote here and then after that comma and for false condition

01:26anybody who has missed appointment once or maybe none I'm just going to leave it as blank like

01:31that and close parenthesis and hit enter and now if I were to double click on this handle here you can

01:37identify or see patients who have actually missed two or more appointments and after that your job is done.

01:44See you then.

01:49You

01:51You

01:53You

01:55You

01:57You

01:59You

02:01You

02:03You

02:05You

02:07You

Number of times patient missed appointments - Excel Tips and Tricks

Category

Transcript

Recommended