Forum Discussion

ExcelandStuff's avatar
ExcelandStuff
Copper Contributor
Feb 25, 2022

How to only show Excel Data for patients with 3 or more no show visists

So I work in healthcare and we are implementing a new No-Show policy.  I can pull data of all patients in our office that are no-show patients but that includes patients who do not qualify for dismis...
excel
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Feb 28, 2022

ExcelandStuff 

365 allows complex formulas to be built up.

= LET(
   patient,      SORT(UNIQUE(name)),
   lastAttended, XLOOKUP(
                 patient, 
                 IF(status="Attended", name), 
                 date, 
                 "Never attended", 0,-1),
   apptCount,    COUNTIFS(name,patient),
   noShows,      COUNTIFS(name,patient, status, "No show"),
   apptRecord,   CHOOSE({1,2,3,4}, patient, lastAttended, apptCount, noShows),
   FILTER(apptRecord, noShows>=3))

 

 

 

Resources