Brothersoft.comWindows|Mac|Mobile|Games

|Message

Solve software problem quickly Share experience to help others Improve the ability of solving problem
Tags:

office tools openoffice.org no duplicates

office tools× openoffice.org× no duplicates×

Done

How to find Duplicates in Open Office Calc?

08/30/2011 04:51 by Chrislo102

First answer posted by TommyB at 08/30/2011 04:51
Add Your Answer
10~1000 characters in length CAPTCHA:
6 Answers
  • TommyB
    1. Paste the list that you will want to filter into OOo Calc.
    2. Select the data that you want to filter. Go to Data >> Filter >> Standard Filter...
    3. Click on More Options. This will take you to more advanced options.
    4. Click on No Duplicates. If you want to create a separate list, click on Copy To... and select a cell address; such as B1.
    5. Select Ok. You will be taken back to your list with the duplicates removed.
  • Was this answer helpful? 10　·　08/30/2011 04:51
  • JPhillippy
  • Select the entire range containing data to filter, then click on the menu Data > Filter > Standard Filter and:
    1. Use a condition that is always TRUE, like field1 = Not empty
    2. Click on the button more, select Remove Duplicate, select Copy to and put the address of an empty cell
    3. The whole range (without duplicate) will be analyzed and copied at that new address.
  • Was this answer helpful? 10　·　11/29/2011 02:14
  • JavyTechGuy
  • I would use two new columns:
    1. In the first one, put a sequential number starting from 1 in the first row, and drag it down (you get 2, 3, etc. in this column)
    2. Sort the range according to the column that will eventually contain duplicate value
    3. In the second new column, put a formula that tests the value if the same as the previous row. If yes, put 1, if not, put 0. Example: =IF(A3=A2;1;0). Copy the formula down the column up to the last row. Rows with a 1 are duplicate rows.
    4. You can now use the filtered list technique mentioned in my previous post to select only these rows and copy them somewhere. Don't use, in that case, the remove duplicate as all rows you want to select have a 1 in the specified column.
    Last, if you want to sort back your range to the initial state, select the whole range and sort it according to the sequential numbers you have created in the first step.
  • Was this answer helpful? 10　·　11/29/2011 02:16
  • Kimplex
  • Find and automatically recalculate unique text values or remove duplicate values in multiple rows or columns.
    Uses if and countif functions.
    Example spreadsheet illustrates:
    1. multiple rows of text
    2. duplicate values in cells of each row
    3. desire to strip out duplicate values in a given row.
    Uses vvjoin macro for concatenation but this is not absolutely necessary.
    Basic concept may be modified easily to deal with columns and/or to present results in different ways.
  • Was this answer helpful? 10　·　11/29/2011 02:19
  • BrianHimlie
  • Coloumn A: This would consist of the dates copied from a database.
    Column B: Would contain formula modifying the dates in coloumn A to give a speicifc format and layout.
    What i am trying to accomplish is remove any duplicates in Column B and count the total number of dates LEFT once the duplicates are removed.
  • Was this answer helpful? 10　·　11/29/2011 02:21
  • NataliaPeterson
  • 1. Coloumn A: This would consist of the dates copied from a database.
    You copy data from a database into a spreadsheet and wonder why you lose most of the database functionality.
    In the database(should work with any database):
    SELECT DISTINCT "Dates" FROM "Tables"
    SELECT COUNT(*) FROM (SELECT DISTINCT "Dates" FROM "Tables")

    2. Column B: Would contain formula modifying the dates in coloumn A to give a speicifc format and layout.
    Apply your "specific number format" to A?
  • Was this answer helpful? 10　·　11/29/2011 02:22
Add Your Answer
10~1000 characters in length CAPTCHA:

0 people are following

Ask a question now
Write a title for your question

More Hot Questions
What do you think of OpenOffice.org?
How can I ensure the cells I merge will stay that way when I go to open the spreadsheet after I have saved my work and closed out of the OpenOffice program?
How do you set a header on cover page different than other pages headers?
How do I restore openoffice.org to default settings without losing my written work?
how to create an OpenOffice Macro?
how to Install Open Office?
Uses of Word Processing Programs
Things to Know When It Comes to Computers
What Are the Paste Options in Word 2007?
Word Processing Teaching Activities

OpenOffice.org

OpenOffice.org is a multiplatform and multilingual office suite.
Latest version:3.4.0 Beta 1/3.3.0
License:Freeware
OS:Windows Vista/2003/XP/2000/98/Me/NT
Total downloads:50,804
Rank:15 in Word Processing
Download It

Share with friends

New features is coming

  • 1. Providing high-quality answers to be a verified Q&A expert
  • 2. Ask and answer questions to get Brothersoft credits

Popular Tags

office tools(28174) photo & image(21438) system utilities(18690) dvd & video(15856) mp3 & audio(5474) home & education(2660) windows(2577) apple "back to the mac" fall 2010 event(2227) facebook "download your information"(2185) social & communication(1873)

Copyright 2002 - 2012 BrotherSoft.com All rights reserved. About Us|Contact Us|Privacy Policy|Safety Policy|FAQ|Submit Software|Advertise With Us

Added Successfully!

×

Are you sure to delete your answer?

NoYes

×

Are you sure to choose it as the best answer?

NoYes

×

Voted Successfully!

×

You can't vote for yourself

×

You can't choose your own answer

×