The easiest way to find places where the same value is used in the same field across multiple records is to use a Summary report. To create one, you can:
1. Choose a table from the Table bar.
2. Click REPORTS & CHARTS to open the reports panel, then click + New.
3. In the dialog, select Summary and click Create.
Now set the view properties to the following: