Remove Duplicates in Open Office Calc
When you are using Open Office Calc for its ability to create orderly lists, you might want to be able to get rid of duplicates. While it isn't as quick and easy as it is in MS Excel, it is possible.
Read on to learn how to do it.
Steps
- Paste the list that you will want to filter into OOo Calc.
- Select the data that you want to filter. After that Go to Data >> Filter >> Standard Filter.
- Click on More Options. This will take you to more advanced options.
- Click on No Duplicates. Change Field Name to 'none'. If you want to create a separate list, click on Copy To... and select a cell address; such as B1.
- Select Ok. You will be taken back to your list with the duplicates removed.
Related Articles
- Learn Spreadsheet Basics with OpenOffice.org Calc
- Create a Check Register with OpenOffice.org Calc
- Manipulate Graphs (Without a Calculator)
- Create a Graph Using a Spreadsheet
- Take Derivatives in Calculus
- Create an Excel Financial Calculator
- Calculate GPA
- Create a Mortgage Calculator With Microsoft Excel
Sources and Citations
- Original information cames from OpenOffice.org
