Filtering the Answerset
You can filter by multiple columns, where each filter is applied to the currently
displayed rows only.
1
Click on the Answerset column header.
A drop down window appears.
2
Do one of the following:
Click on the check boxes 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) will depend on the data type of the column.
Note: Use Find instead of filtering a large spreadsheet by a unique column.