5 Replies Latest reply on Nov 27, 2018 4:53 PM by Paul Wachtler

    Identifying Duplicates Within A Date Range

    Victor Alcala

      Hi All,

       

      I have a dataset of 8,000 participants receiving services over the past three years. I'm working with some duplicated participants that received the same service multiple years. The statements I need to make are as follows:

       

      In 2018, we had X number of first time participants, X number of repeat participants and a total of X number of unduplicated participants.

       

      In 2017, we had X number of first time participants, X number of repeat participants and a total of X number of unduplicated participants.

       

      I've looked around and found some calcs to figure the duplicate counts, but I'm having trouble filtering by year because it then excludes previous year info, throwing off the count

       

       

      Attached is a sample of the excel sheet I'm working with.

       

      Any help is greatly appreciated!!!