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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/de\/Remove-Duplicates-in-Open-Office-Calc-Step-1-Version-2.jpg\/v4-460px-Remove-Duplicates-in-Open-Office-Calc-Step-1-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/de\/Remove-Duplicates-in-Open-Office-Calc-Step-1-Version-2.jpg\/aid1598687-v4-728px-Remove-Duplicates-in-Open-Office-Calc-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Remove-Duplicates-in-Open-Office-Calc-Step-2-Version-2.jpg\/v4-460px-Remove-Duplicates-in-Open-Office-Calc-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/1\/1e\/Remove-Duplicates-in-Open-Office-Calc-Step-2-Version-2.jpg\/aid1598687-v4-728px-Remove-Duplicates-in-Open-Office-Calc-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    After that Go to Data >> Filter >> Standard Filter.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d2\/Remove-Duplicates-in-Open-Office-Calc-Step-3-Version-2.jpg\/v4-460px-Remove-Duplicates-in-Open-Office-Calc-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/d2\/Remove-Duplicates-in-Open-Office-Calc-Step-3-Version-2.jpg\/aid1598687-v4-728px-Remove-Duplicates-in-Open-Office-Calc-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    This will take you to more advanced options.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Remove-Duplicates-in-Open-Office-Calc-Step-4-Version-2.jpg\/v4-460px-Remove-Duplicates-in-Open-Office-Calc-Step-4-Version-2.jpg","bigUrl":"\/images\/thumb\/7\/7f\/Remove-Duplicates-in-Open-Office-Calc-Step-4-Version-2.jpg\/aid1598687-v4-728px-Remove-Duplicates-in-Open-Office-Calc-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/79\/Remove-Duplicates-in-Open-Office-Calc-Step-5-Version-2.jpg\/v4-460px-Remove-Duplicates-in-Open-Office-Calc-Step-5-Version-2.jpg","bigUrl":"\/images\/thumb\/7\/79\/Remove-Duplicates-in-Open-Office-Calc-Step-5-Version-2.jpg\/aid1598687-v4-728px-Remove-Duplicates-in-Open-Office-Calc-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    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
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Learn Spreadsheet Basics with OpenOffice Calc
      How to Find Derivatives
      How to Create a Financial Calculator in Microsoft Excel: Step-by-Step Guide
      How to
      Calculate GPA
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Use OpenOffice Writer
      How to
      Print Address Labels Using OpenOffice
      How to
      Make Labels Using Open Office Writer
      Advertisement

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 231,046 times.

      Is this article up to date?

      Advertisement