3 Replies Latest reply on Mar 27, 2020 7:20 AM by hina.waheed.0

    CountD on PHI

    hina.waheed.0

      Hello,

       

      I worked really hard to provide a replica of my issue, so hopefully I can get some answers

      Looking at the workbook attached, I want to count only one test result per person. For example, if they were tested but no results then pending, however if the test results came back the same or next day then i want to count only the new result that came in. Below it shows that person 1 was tested on 3/8/2020 and results were pending, but then the same day results came back as negative. So there should be 1 in negative and 0 in pending. How do i calculate for that information?

       

      As a note- there will be many times where test results do not come back the same day!