Download Article
An easy-to-follow guide on hiding duplicates in Open Office Calc
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
-
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.Advertisement
-
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.
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,505 times.
Advertisement