OpenOffice Calc: Find and remove duplicate entries
In this practical tip, you will learn how to find and remove duplicate entries in the OpenOffice spreadsheet.
Remove duplicate entries in the OpenOffice spreadsheet
- In OpenOffice, mark the table area from which duplicates are to be removed.
- Select Data> Filters> Standard Filters.
- Set the condition field name "none", condition "contains".
- Click on "More Options" to make additional settings.
- Check "No duplicates".
- Confirm with "OK". The duplicate entries have been removed from your table.
Read another practical tip on how to insert text fields in OpenOffice.