IBM Lotus Symphony


Setting options for filters

Displays or hides additional filtering options.

Options

Case sensitive

Distinguishes between uppercase and lowercase letters.

Regular Expression

Allows you to use wildcards in the filter definition.

If the Regular Expression check box is selected, you can use EQUAL (=) and NOT EQUAL (<>) also in comparisons. You can also use the following functions: DCOUNTA, DGET, MATCH, COUNTIF, SUMIF, LOOKUP, VLOOKUP and HLOOKUP.

Unique records only

Excludes duplicate rows in the list of filtered data.

Data area

Displays the name of the filtered data area in the table.

More<<

Hides the additional options.


Product Feedback | Additional Documentation | Trademarks