Fyear | MIS | Rescode | Treating_Hospital | HCN | Visits |
2018 | Dialysis_Home | 0240 | Grey-Sloane | 5555555555 | 1 |
2018 | Dialysis_Home | 0240 | Grey-Sloane | 5555555555 | 1 |
2018 | Dialysis_Other | 0200 | Grey-Sloane | 4444444444 | 1 |
2018 | Dialysis_Other | 0232 | Sunshine Hospital | 5555555555 | 1 |
2018 | Dialysis_Other | 0240 | Grey-Sloane | 5555555555 | 1 |
2019 | Dialysis_Home | 0200 | Sunshine Hospital | 4444444444 | 1 |
2019 | Dialysis_Home | 0232 | Grey-Sloane | 5555555555 | 1 |
2019 | Dialysis_Home | 0240 | Grey-Sloane | 5555555555 | 1 |
2019 | Dialysis_Other | 0200 | Grey-Sloane | 5555555555 | 1 |
2019 | Dialysis_Other | 0240 | Sunshine Hospital | 5555555555 | 1 |
For the table above, I'd like to find distinct count of the HCN field (unique identifier for patient) with the filters of fyear, MIS, rescode and treating hospital. So for the above, if the fiscal year is 2018, the MIS is dialysis_home, the rescode is 0240 and the treating hospital is Grey-Sloane, there should be 1 distinct patient.
I don't know how to link other posts but in an August 17, 2020 post about distinct counts based on patient IDs, Eric W responded with =SUM(SIGN(FREQUENCY(IF(C2:C6=G2,IF(D2:D6=H2,E2:E6)),E2:E6))) where E was the patient identifier. This works for my example if the HCN is a number field but in my case it is not so can Eric W's response be edited for use with text? Thanks for any and all assistance.