Hello everyone,
I'm working on a huge data set on excel. The data consists of patient names and the medications they are on. The medication gets renewed after certain period of time by physicians if needed and the renewed medications are listed twice / thrice (depending on number of times they are renewed).
I need to find out all the patients who have at least 5 or more medications renewed (that means appearing more than once). Can someone help me with this please?
My understanding is that if I can somehow use count function - something like...For each patient, count no. of repeat medications and then filter where the total count is 5 or more.
Here is what the data looks like:
Name Medication Name
John Med A
John Med A
John Med B
John Med C
John Med D
John Med D
John Med D
John is on 4 medications and out of that 2 are repeated more than once. So I'm interested in calculating this no. '2'. Once done I can do a filter.
Thanks and hoping to get the solution on this great forum.
R
I'm working on a huge data set on excel. The data consists of patient names and the medications they are on. The medication gets renewed after certain period of time by physicians if needed and the renewed medications are listed twice / thrice (depending on number of times they are renewed).
I need to find out all the patients who have at least 5 or more medications renewed (that means appearing more than once). Can someone help me with this please?
My understanding is that if I can somehow use count function - something like...For each patient, count no. of repeat medications and then filter where the total count is 5 or more.
Here is what the data looks like:
Name Medication Name
John Med A
John Med A
John Med B
John Med C
John Med D
John Med D
John Med D
John is on 4 medications and out of that 2 are repeated more than once. So I'm interested in calculating this no. '2'. Once done I can do a filter.
Thanks and hoping to get the solution on this great forum.
R