Defining a data area

You define a data area in two steps:

  1. Define the conditions that must be met by the values to be filtered. You can combine two conditions.
    Overview of the comparison operators
    * A condition is not specified (default setting). The input box is disabled.
    = Only the entered value will be taken into account.
    >= All values above and including the entered value will be considered.
    <= All values below and including the entered value will be considered.
    > All values above the entered value will be considered.
    < All values below the entered value will be considered.
    <> The value range above and below the entered value will be considered.
  2. Define the data area by specifying the cell values by which the data will be filtered. If you do not select an element, the complete dimension is used. This is the default setting and is indicated by an asterisk (*).