In this video we can discuss about How to work with Flash Fill & Remove Duplicates Options in Excel Sheet.
Remove Duplicates:-
Remove Duplicates window check the boxes next to the columns you would like the duplicate data removed. Then click OK and all duplicates will be deleted from the spreadsheet.