Using the values in the current column, any row that contains the same value as the current cell is removed from the spreadsheet. You can combine this with other restrictions.
- From the menu select Spread | Restrict/Filter | Values Not Equal to the Current Cell.