You want to remove Duplicate data in your excel sheet. You can Find, highlight the duplicates befor…