The duplicate data in a spread sheet is the one where all the values in a given row match with the all the values in another row.To remove the duplicate data either you can first filter the table and then apply the “remove duplicate” option or directly apply the option.
The following example shows how to remove duplicate data.
1. Sort the data.
2. Go to Data-> Remove Duplicates.
3. Select Column in which you want to remove duplicates.
4. Result: See the duplicate entries are removed from the data.
1,673 total views, 2 views today