The Ability Spreadsheet data filter enables the user to select spreadsheet rows by setting criteria for the data in a particular column. You may, for example, want to select only those rows which contain a figure greater than, say, $10,000 dollars in a column of monthly sales figures.
There are two types of filters: Auto Filter and Advanced Filter.