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.
  1. Sort the data range by column A.
Choose Data - Sort.

  1. 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.


  1. Copy the formula down for all rows of the data range.
  2. Drag the formula to last cell of the data present against to Column A
  3. Now filter Column C and select 1's in filter dropdown and delete
  1. Re-set(Open the filter and select All and Click on OK) the filter you can find desired unique values in Column A.