| |
Advanced
Filter
Although
the AutoFilter makes selecting records very simple, you may
wish to have more control over the criteria used. You can
place criteria on the spreadsheet itself and use an Advanced
Filter to select records. You then tell the computer the location
of the records, the location of the criteria, and whether
the list should be filtered in-place or copied to another
location.
For this
example, we'll add four rows to the top of the spreadsheet.
(<Click here>
if you would like to see a video demo of this.) We'll then
copy the column headers to row 1.
 |
Notice
the criteria in row 2. Since the criteria are on the same
row, the computer will assume this to be an AND criteria.
For the record to be selected, the Salesperson has to
be Akers and the Sales have to be greater than $27,000.
We now click back in the table and choose the Data|Filter|Advanced
Filter menu. |
 |
By
clicking in the table first, the computer automatically
selected the correct range for the table. We can now enter
the range for the criteria. (A1:C2). Here is the resulting
list. |
 |
It
should be noted that by clicking on the Copy to Another
Location option, we would then also choose a starting
cell for where the new list should be copied. |
If we
moved the ">27000" from row 2 to row 3, we create an OR criteria.
This means a record will show if EITHER criteria is true.
When we choose Data|Filter|Advanced Filter, however, we must
remember to change the criteria range. Here is the list when
we do this.
|
