Find cells that have matching values using the Select Matching Cells option.
• Select Rows > Row Selection > Select Matching Cells
or
• Right-click one of the highlighted row numbers and select Select Matching Cells.