As an X-Ray tech I have to log every exam I do. What I'd like is something that tells me how many patients I radiographed per day, but not adding duplicate names. My log looks like this:



Patient Name Date Gender DOB Exam Views Physician
Patient 1 04/01/19 M 01/01/70 Chest 2 Physician A
Patient 2 04/01/19 F 02/01/70 Left Hand 3 Physician B
Patient 2 04/01/19 F 02/01/70 Left Wrist 3 Physician B
Patient 3 04/01/19 M 03/01/70 Lumbar Spine 2 Physician A
Patient 4 04/01/19 M 04/01/70 Right Shoulder 2 Physician A
Patient 5 04/02/19 M 05/01/70 Right Foot 3 Physician B
Patient 6 04/03/19 F 06/01/70 Cervical Spine 5 Physician A

How can I get my output to not count Patient 2 twice?