You can filter by multiple columns, where each filter is applied to the currently displayed rows only.
Use Find instead of filtering a large spreadsheet by a unique column.
- Click on the Answerset column header.
-
In the drop-down window, do one of the following:
- Select the checkboxes next to the list of column values to include or exclude rows that contain that column value. For dates and timestamps, the list is replaced by a Tree that allows you to select at the year, month, day level.
- Click Number filters, then select a condition from the displayed sub-menu. In most cases, a dialog into which you can enter a value for the condition appears.
- Click Text filters, then select a condition from the displayed sub-menu. In most cases, a dialog into which you can enter a value for the condition appears.
- Click Date filters, then select a condition from the displayed sub-menu. In some cases, a dialog into which you can enter a value for the condition appears.
- Click Filter by Color, then click one of the listed colors to display only those rows that use that background color in this column.
- Click Clear filter from ‘xxx’ to remove any existing filter from this column. The type of filter displayed (Number, Date or Text) depends on the data type of the column.