1 Reply Latest reply on Oct 10, 2013 9:59 AM by Brian Havlin

    How can I find duplicates within my form?

    SteddfodGen

      I'm trying to find a way to track down if we get any duplicate entries in our form. I've seen the filter option but not sure I'm using it correctly as it seems I would still need to go through all the names to find the duplicates.

        • 1. Re: How can I find duplicates within my form?
          Brian Havlin Adobe Employee

          Hi,

           

          Here's one approach that uses the COUNTIF function to help identify duplicate entries. In the screenshot below, I have created a "Count" column with an expression that counts the number of occurrences of each cell value within the Email column.

           

          count.png

          The next screenshow shows the table content after applying the expression:

           

          count_result.png

          You could then sort or filter on the Count column to identify duplicate entries.

           

          Regards,

          Brian