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