Sample data below.
Don't want a report per say, but want to see when I select Customer Number - 1 there's a field (countif formula) that shows the exact same value in [Customer Phone] occurs 4 times in this table (countif in excel). If it was possible for the value in my countif formula once I click it to bring me to a report with all matching numbers, would be ideal. Then I need to apply this logic/formula to many other fields.
Customer Number Customer Name Customer Phone
1 John Smith 123-456-7890
2 Jane Does 123-456-7890
3 Gilbert Grape 123-456-7890
4 John Deere 321-456-7890
5 Darth Vader 123-456-7890
