Opcijas

Displays or hides additional filtering options.

Opcijas

Reģistrjutīgs

Distinguishes between uppercase and lowercase letters.

Regulārā izteiksme

Allows you to use regular expressions 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.

No duplications

Izkļauj dublējošās rindas filtrēto datu sarakstā.

Datu diapazons

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