Thank you both.
ArviLaanemets, I started implementing your method in a very big excel workbook. I was approached by the requester to clarify further. Here is the clarification:
Everything remains the same what changed is that we are looking for individuals with H0004 and then getting the other codes within the same week (within 7 days). I think this will reduce the result tremendously.
I modified & attached a sample workbook.
TIA
Regards,
|