Download Article
An easy-to-follow guide on hiding duplicates in Open Office Calc
Download Article
X
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 235,477 times.
Learn more...
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
Download Article
-
![Step 1 Paste the list that you will want to filter into OOo Calc.]()
Paste the list that you will want to filter into OOo Calc. -
![Step 2 Select the data that you want to filter.]()
Select the data that you want to filter. After that Go to Data >> Filter >> Standard Filter.Advertisement -
![Step 3 Click on More Options.]()
Click on More Options. This will take you to more advanced options. -
![Step 4 Click on No Duplicates.]()
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. -
![Step 5 Select Ok.]()
Select Ok. You will be taken back to your list with the duplicates removed.
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
Thanks for submitting a tip for review!
About This Article
Thanks to all authors for creating a page that has been read 235,477 times.
Is this article up to date?
Advertisement
