If you want to Remove Duplicates In Excel then you must follow these steps:-
1. Firstly, open Excel Spreadsheet and select the Range of Data, you want to remove duplicates.
2. Then click on the Data tab and Locate and remove Duplicates in the Data Tools Group.
3. Now select the Columns to check for duplicates, in the remove duplicates window.
4. Then click the My Data has headers and click OK.
5. Finally, your duplicate entries will be removed.
Read More:- https://allinsider.net/remove-duplicates-in-excel/