count the number of tests analyzed based on patient and date range

%3CLINGO-SUB%20id%3D%22lingo-sub-2107490%22%20slang%3D%22en-US%22%3Ecount%20the%20number%20of%20tests%20analyzed%20based%20on%20patient%20and%20date%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2107490%22%20slang%3D%22en-US%22%3EHi%2C%20I%20need%20to%20count%20the%20number%20of%20times%20a%20test%20is%20analyzed%20where%20one%20should%20only%20count%20cases%20at%201%20month%20intervals%20for%20each%20patient.%3CBR%20%2F%3Esee%20attached%20example.%3CBR%20%2F%3E%3CBR%20%2F%3Ehope%20someone%20can%20help%20with%20this.%20Until%20now%2C%20I%20have%20tried%20the%20%22if%22%20formula%2C%20but%20have%20not%20succeeded.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2107490%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor
Hi, I need to count the number of times a test is analyzed where one should only count cases at 1 month intervals for each patient.
see attached example.

hope someone can help with this. Until now, I have tried the "if" formula, but have not succeeded.
1 Reply

Hi @ingeoa88 

 

I did not undertand why you did not wanted 20.02.2020 to be counted, because that does not follow the pattern. 

 

The combination Patient ID and month Value would be a Uniq value. And you will only get 11 12 111. Counting teh leftmost value in that dynamyc list will give you the result. 

 

Best Regards

- Geur