1 2 Previous Next 15 Replies Latest reply on Oct 26, 2016 7:33 AM by Joe Oppelt

    how to filter one item and view all matches

    Peter Phung

      Hello, I'm trying to find duplicates of phone numbers in my database. For example these are my results

       

      Rows: Phone Number | Last Name

      Filter: Count(Phone Number) > 1

       

      phone list.PNG

       

      The list is very large, over 30000 lines. I can make a quick filter dropdown for the user to select a last name and show those results.

      If ? is selected I want it to show:

       

      phone list2.PNG

       

      How do I get the other names that also have the same phone number as "?" to display as well?

       

      Thanks,

      Peter

        1 2 Previous Next