L.2.2.12 AutoFilter

<autoFilter ref="D5:H11">
  <filterColumn colId="0">
    <filters>
      <filter val="A"/>
    </filters>
  </filterColumn>
  <filterColumn colId="1">
    <customFilters and="1">
      <customFilter operator="greaterThan" val="0"/>
      <customFilter operator="lessThan" val="0.7"/>
    </customFilters>
  </filterColumn>
</autoFilter>

AutoFilters specify criteria for which cells in a table should be displayed. In this example, the first column (zero-based index colId) in the table (cells D5:D11) has a criterion specifying that only rows in the table whose values in column D are equal to A are shown. The rest of the rows are hidden.

A second criterion is specified as well, on the 2nd column, E: only rows whose values in column E are greater than 0 and less than 0.7.

The resulting grid could be rendered like this: