Forum Discussion
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...
OliverScheurich this works great! Is there any way that I can find out how many no-shows each of these patients have? I've been messing around with the UNIQUE/COUNT formula trying to figure it out myself
With these formulas the number of no-shows for each patient can be calculated in my spreadsheet.
=COUNTIF($A$2:$A$54,F2)In the attached example i have this formula in cell G2.
=UNIQUE(A2:A54)This is the formula in cell F2.