| A | B |
|---|
| AND | Finds records that meet two conditions |
| OR | Finds records that meet one criteria or another |
| AutoFilter | Filter using arrows displays records meeting the AutoFilter criteria |
| Record meeting two criteria on different fields | Place the criteria on the same row in the Criteria range |
| Custom AutoFilter | Uses to search for values using operators |
| Clear | Redisplay data |
| A??? | Search criteria to find a word starting with A and followed by three characters. |
| Top 10% modified to find 25% | Find the highest 25% |
| AutoFilter | This does not let you copy records found in a search to another range on the worksheet |
| AND | Can be used in the advanced filter and in the Autofilter |
| DSUM Function | Averages a field of values in a database |
| Top 50% in the top dialog box would | display the first 50% of records |
| Search Operator for C | will display both upper and lower case letters |
