Remove Duplicates in Sheets Windows
With OfficeSuite Sheets, you can easily search and remove any duplicates of data in columns.
1. Open your Sheets document.
2. Select a column or a range of columns (left-click and drag).
3. Click Data from the main ribbon.
4. Click Remove Duplicates.
5. After the selection of columns, confirm with OK.