Removing Duplicate Rows in ODS/Spreadsheet

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

1. Select all cells of the current data range.

2. Sort the data range by column A.

Choose Data - Sort.

3. Click an empty cell in the first row. Let's assume it is cell C2. Enter the formula:

=IF(A2=A3;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.

4. Copy the formula down for all rows of the data range.
5. Drag the formula to last cell of the data present against to Column A
6. Now filter Column C and select 1's in filter dropdown and delete

7. Re-set(Open the filter and select All and Click on OK) the filter you can find desired unique values in Column A.