If you don’t know How To Remove The Duplicate Values In Excel by using formulas then follow these steps:-
1. The first step is to select the Row, where you want to apply the formula.
2. Then select the Row, where you want to copy your duplicate free data. 
3. Now enter the Formula in the formula box.
4. Then click Yes.
5. Finally, you will see your data has been copied without any duplicate entries.