Finding duplicate rows in Excel?

Question

excel

The table has 2 columns. One has 100 names and the other has 200. How can I compare these two columns and display the same values ​​in both columns?

Answer 1

Conditional formatting solves elementary.
In the screenshot - the rule for the range B:B. A similar rule is made for A:A.

Answer 2

Option 1

1. We select the table in which it is necessary to detect duplicate values.
   
2. Go to the Home tab in the Styles group
   
3. Select Conditional Formatting -> Cell Selection Rules -> Duplicate Values
   

Option 2

1. Select and copy the 1st column
   
2. We go to the site ( https://pr-cy.ru/duplicates/ ) and paste all the values, then click "Delete Duplicates", copy all the values ​​(they are already without duplicates) and paste them into excel
   
3. Do the same with the 2nd column
   

Answer 3

Write a small VBA script. There, only two nested loops will need to be written.