How to Remove Duplicates in Two Rows in OpenOffice

Remove duplicate data from your spreadsheet to prevent future complications.
••• Stockbyte/Stockbyte/Getty Images

If not removed, duplicate row data in your OpenOffice Calc files can run the risk of interfering with the accuracy of your spreadsheet statistics. While OpenOffice Calc does not offer an integrated tool to remove duplicate data, you can use a formula to pinpoint the duplicates in your rows and then use the Sort tool to select and remove them from your file. Using the formula to detect the duplicates in your rows is particularly helpful if you're working with a large amount of information.

Digging for Duplicates

In your OpenOffice spreadsheet, select all of the columns that hold your data. Under "Data," click "Sort" and sort your data by column A in Ascending or Descending order. Click on the next empty cell in your first row (for instance, if your data ends in column C, click on empty cell D1). Type in the formula "=IF (A1=A2;1;0)" and then press the "Enter" key.

Drag the handle in the lower right corner of the cell to copy the formula to all rows. The formula will place a "1" next to any row it recognizes as a duplicate. OpenOffice recommends that you copy the values produced by the formulas over the formula cells themselves to freeze the contents.

Copy all of the cells in your formula column, then press "Shift-Ctrl-V." Check "Number" in the Paste Special window, but leave all other fields unchecked and click "OK." Next, sort all of your data by the column with your formula results. All of the rows marked "1" are duplicates and will now be grouped together so you can delete them.

Related Articles

How to Do Algebra in Excel
How to Subtract Matrices on Excel
What Does ##### Mean in Excel?
How to Make a Coordinate Plane in MS Excel
How to Graph a Distribution for a T-Test
How to Find Correlation Coefficient & Coefficient of...
How to Calculate Correlation Coefficient Between Two...
How to Calculate Regression Coefficient
How Do I Calculate the Relative Standard Deviation...
How to Calculate Pearson's R (Pearson Correlations)...
How to Clear Matrices on a TI-84
How to Express "Divisible By" in Excel
How to Solve 3-Variable Linear Equations on a TI-84
How to Translate Bar Codes
How to Calculate Slope Using the TI-83 Plus
How to Determine the Bin Width for a Histogram
How to Reset a TI-84 Calculator
How to Know if Something Is Significant Using SPSS
How to Create Matrices on a TI-89
How to Calculate the Percent Change in Excel

Dont Go!

We Have More Great Sciencing Articles!