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

    How can I find duplicates within my form?


      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



          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.



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



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