Use this to apply a filter/restriction to the spreadsheet that displays only the first row for each unique combination of the selected columns. That is, the rows displayed will represent the first occurrence of each combination of ID columns in the spreadsheet. This filter can either replace any existing filters on the spreadsheet or be added to the existing filters. An option allowing case insensitive comparisons to be made for text columns can be selected, enabling items with different cases of the letters to be distinguished or combined.
This filter is useful for quickly viewing what combinations of items present in the spreadsheet.
Available columns
This lists all the columns within the spreadsheet. Select the columns that define the row IDs to filter on. Use the button to transfer these into the list of Selected ID columns, or double-click items in this list to transfer them to the Selected ID columns list.
Selected ID columns
This lists the columns within the spreadsheet whose combination of values define the row IDs. Use the button to remove columns that have been selected from this list of columns, or double-click the entries to remove them.
Ignore case on text comparisons
If selected, text values with the same letters but different cases will be treated as a match, otherwise the comparisons will be case sensitive and items will need the same case to match. For example, yes, Yes and YES will be treated as a single item if this option is selected, and as separate items if it is not.
Combined with existing restriction
This option is enabled if the spreadsheet already has a filter/restriction applied. If selected, only unique combinations within the currently included rows will be displayed, otherwise the existing restriction will be cleared before applying the new restriction.
See also
- Spreadsheet Restrict/Filter Menu for other methods of defining restrictions.
- Restrict Units by Value
- Restrict using Factor Levels
- Restrict using Expression
- Restrict Duplicate Rows
- Restrict/Filter Random Rows
- Save Restriction/Filter
- Understanding Factors within a Spreadsheet
- Spreadsheet Restrict/Filter Menu
- Spreadsheet Delete Menu for deleting selected rows.
The RESTRICT directive can be used to filter columns within the command language.