Hi,
Im trying to count the number of unique drugs given to patients in an excel array, I currently use =SUMPRODUCT(1/COUNTIFS(B2:B9,B2:B9)) however I have to manually shift the cells when the Pt ID changes as the number of drugs given is different for each patient. Is there a way to display the Pt ID when the value changes as well as counting the total number of drugs given to that patient?
Im trying to count the number of unique drugs given to patients in an excel array, I currently use =SUMPRODUCT(1/COUNTIFS(B2:B9,B2:B9)) however I have to manually shift the cells when the Pt ID changes as the number of drugs given is different for each patient. Is there a way to display the Pt ID when the value changes as well as counting the total number of drugs given to that patient?