How to Remove Duplicates in Open Office Calc

PDF download Download Article
An easy-to-follow guide on hiding duplicates in Open Office Calc
PDF download Download Article

When you are using OpenOffice Calc for its ability to create orderly lists, you might want to be able to get rid of duplicates. Read on to learn how to do it.

Steps

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

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement

Video

Tips

Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Submit
Thanks for submitting a tip for review!

You Might Also Like

Find Duplicates in Excel
How to
Find Duplicates in Excel
Excel How to Remove Blank RowsStep-by-Step Guide to Removing Blank Rows in Excel (or Google Sheets)
Create a Filter View on Google Sheets
How to
Create a Filter View on Google Sheets
Use AutoFilter in MS ExcelEasy AutoFilter Basics for Beginners
Delete Duplicate Records in OracleEverything You Need to Know About Removing Duplicate Records in Oracle
Filter by Color in Excel
How to
Filter by Color in Excel
Hide Columns in Excel
How to
Hide Columns in Excel
Clear Filters in Excel2 Simple Ways to Clear Filters in Microsoft Excel
Hide Rows in Excel
How to
Hide Rows in Excel
Group and Outline Excel Data
How to
Group and Outline Excel Data: Easily Collapse Rows of Info
Delete Duplicates in Word
How to
Delete Duplicates in Word
Make Tables Using Microsoft ExcelSimple Steps to Make Tables in Excel
Use the Lookup Function in Excel
How to
Use the Lookup Function in Excel
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Advertisement

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, 9 people, some anonymous, worked to edit and improve it over time. This article has been viewed 239,113 times.
How helpful is this?
Co-authors: 9
Updated: March 27, 2024
Views: 239,113
Categories: OpenOffice.org
In other languages
Thanks to all authors for creating a page that has been read 239,113 times.

Is this article up to date?

Advertisement