How To Remove Duplicate Entries in OpenOffice.org Software

Open Source Software - Free Software

OpenOffice.org offers an open source option for users that is very similar to Microsoft Office and is compatible with Macs. Although Microsoft Office offers software solutions for Mac users, there are times that the software is unavailable. OpenOffice.org is a completely free download that offers programs that are similar to MS Word, MS Excel, MS PowerPoint as well as drawing programs and an extensive database creation program. It is compatible with the Microsoft software with the option to save in several different formats. Despite the similarity, there are a few differences with functions that are used on a regular basis. One of the functions that I ran into is how to remove duplicates from a spreadsheet. Although the process is very similar to the older '93 version of the MS software, the newer programs have the function programmed in as a one-click function.

This tutorial will show you how to successfully remove the duplicates from a calc documnt (spreadsheet) in OpenOffice software.


List With Duplicates

Original List
Original List

Step One

1. Select the data column that you want to remove the duplicate data. In this tutorial we will be removing the duplicate email addresses. You can select the entire column by selecting the letter at the top of the column (in this case 'c').

Select The Field You Need To De-Dup

Select only the column of data that you want to remove the duplications - in this case the email addresses
Select only the column of data that you want to remove the duplications - in this case the email addresses

Step Two

2. Once the data is selected go to "data" -> and select "filter".

Step Two

Next step is to apply a filter. A filter will not delete the data, it will just hide the data.
Next step is to apply a filter. A filter will not delete the data, it will just hide the data. | Source

Step Three

3. You will then have a new dialog box pop up with a few options. In the "field name" the appropriate title matching your data. If you selected just that one column, it should default to the correct column.

In "value" choose "-not empty-.

Choose "more options" and the dialog box will open up with the duplicate options. If you do have column labels (headings) keep that checked. Then check "no duplication". Choose "OK".

Hiding the Duplicates

Choose "more options" for the option to remove duplicates
Choose "more options" for the option to remove duplicates | Source

Duplicates Hidden - Not Removed

The cells have just been hidden with the filter, not yet deleted.
The cells have just been hidden with the filter, not yet deleted.

Steps to Remove The Duplicates

At this point you just 'hidden' the duplicate entries, you have not yet deleted them. You can see this by your line numbers, you will see that some numbers are no longer showing.

To delete the entries is as easy as copying and pasting. Select all of the fields (you can do this by choosing the cell in the far upper left corner between the cell numbers and the headings). Copy all of the content, open a new calc sheet and then paste. Save the spreadsheet and you will see that all of the numbers are now in order again.

Other How-To Articles

  1. How To Create Interactive PDF Forms - this is a step-by-step tutorial that will show you how to create your own custom PDF form that can be used for a variety of projects.
  2. A Guide To Graphic Design Templates - this includes setting up publication templates, margins, bleeds and other guru tips and tricks using Adobe InDesign.
  3. How to Create Your Own Joomla Template - a step-by-step tutorial that will walk you though how to create your own custom Joomla template, work with PHP programming language and upload to your own Joomla website.

┬ęCopyright 2012 by DAPPLE DESIGNS (MELISSA MILLER)

More by this Author


Comments

No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working