Deleting Duplicates in OpenOffice

[Bansi_WADIA]

Hello

I have a csv file that I opened with OpenOffice Calc ,This file includes a dozen columns and over 37,000 lines Among these columns there is a column that includes mail messages so the people who registered on my site to do a survey. But I found many duplicate emails I would like to eliminate all lines whose address is duplicated. Do you know how to do that?

In advance thank you

[chroma]

1: Select your column containing the addresses to filter, then apply the filter

2: Once the filtered rows, select, copy (Ctrl + C) and paste (Ctrl + V) on the new sheet.

[ThoMas321]

hello

You can view the duplicates in a range of cells, using the conditional format function.
If for example you want to identify duplicates in the range A1: A20,

• Select cell A1.
• Choose Format
• Conditional Format
• Condition1, select the option "The formula is: Indicates field in the conditional:

Select All Zoom
NB.SI($A$1:$A$20;A1)>1

• Sets the cell style.
• Click on the OK button to confirm.
• Applies the same format followed in other cells in the test.

[kattman]

There is no automatic function to remove duplicate rows. Follow these steps to delete all rows that have duplicate values in column A:

Select all cells of the current data range.
On most systems, you can click any cell inside the data range, then press Ctrl+Multiplication key on the numeric keypad.
Sort the data range by column A.
Choose Data - Sort.
Click an empty cell in the first row. Let's assume it is cell C1. Enter the formula:
=IF(A1=A2;1;0)
This will display 1 if the current row has the same value in column A as the next row. It will display 0 if the values are different.
Copy the formula down for all rows of the data range.
Drag the lower right edge of the cell C1 down to the last row.
Now the formulas must be replaced by their values to freeze the contents.
While the column C is still highlighted, press Ctrl+C to copy all selected cells to the clipboard.
Press Shift+Ctrl+V to open the Paste Special dialog box.
In the Selection area, enable only the Numbers command; disable the other Selection commands. Click OK.
Select the whole data range including the new column C and sort the range by column C.
Choose Data - Sort.
Select all rows which have a value 1 in column C, then press Del key.
Optional steps: Delete column C. Select the remaining rows and sort them again by column A.

Tip: This method can also be used to remove duplicate text lines from a Writer document. Copy the text to a Calc spreadsheet. Remove the duplicates, then copy and paste back as "unformatted text" to Writer.