I am counting patients by a specific clinic with a specific visit type. I am using the COUNTIFS formula. I have discovered that some patients have had their clinic visit on a specific date documented twice, and I do not want to count the duplicate entry. There is a unique visit identifier for each visit. If the patient has the same visit ID more than once, I only want to count it once. I am not sure how to work that into the formula. In the image below, if I am counting CLINIC B that had a TYPE C visit, the count would come up as 3, when really there was only 2.
NAME | DATE | CLINIC | VISIT TYPE | VISIT ID |
PT A | 7/12/2020 | CLINIC B | TYPE C | 123456 |
PT A | 7/12/2020 | CLINIC B | TYPE C | 123456 |
PT B | 7/12/2020 | CLINIC F | TYPE G | 23412 |
PT C | 7/14/2020 | CLINIC C | TYPE W | 45623 |
PT F | 7/20/2020 | CLINIC B | TYPE C | 895432 |