Using the values in the current column, any row that does not contain 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 Equal to the Current Cell.