How to Remove Duplicates in Open Office Calc

An easy-to-follow guide on hiding duplicates in Open Office Calc

When you are using OpenOffice 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

  1. Image titled Remove Duplicates in Open Office Calc Step 1
    1
    Paste the list that you will want to filter into OOo Calc.
  2. Image titled Remove Duplicates in Open Office Calc Step 2
    2
    Select the data that you want to filter. After that Go to Data >> Filter >> Standard Filter.
    Advertisement
  3. Image titled Remove Duplicates in Open Office Calc Step 3
    3
    Click on More Options. This will take you to more advanced options.
  4. Image titled Remove Duplicates in Open Office Calc Step 4
    4
    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.
  5. Image titled Remove Duplicates in Open Office Calc Step 5
    5
    Select Ok. You will be taken back to your list with the duplicates removed.
    6. Advertisement

You Might Also Like

Learn Spreadsheet Basics with OpenOffice Calc
How to
Learn Spreadsheet Basics with OpenOffice Calc
Take Derivatives
How to
Take Derivatives
Create an Excel Financial Calculator
How to
Create an Excel Financial Calculator
Calculate GPA
How to
Calculate GPA
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Use OpenOffice Writer
How to
Use OpenOffice Writer
Make Labels Using Open Office Writer
How to
Make Labels Using Open Office Writer
Print Address Labels Using OpenOffice
How to
Print Address Labels Using OpenOffice
Advertisement

References

  1. Original information cames from OpenOffice.org

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 212,738 times.
How helpful is this?
Co-authors: 8
Updated: August 13, 2022
Views: 212,738
Categories: OpenOffice.org
Advertisement