How to remove a duplicate row in Excel?

Question

excel

There is a table of the form
No. Name Site
1 vvyfaa ayfafyayu.ru
......
Sometimes either the names or the names of the site are repeated, how to remove the repetition, but leave 1 unique position

Answer 1

Select the range to remove duplicates, then in the "Data" menu, select "Remove Duplicates"
In the "Remove Duplicates" dialog box, click "OK"