To work with Advanced Filters<\/strong> in Excel, you need to understand a few of the concepts that are used. A list in Excel is a series of rows of information. Each row is effectively one unit of information. This structure is very similar to a simple database and therefore uses similar terminology to describe the parts of the list. The following illustrates a list and its parts.<\/p>\n\n\n\n A field<\/strong> is a column<\/strong> in the list of data. In the example below, the Last Name column is an example of a field.<\/p>\n\n\n\n The field name<\/strong> is the heading<\/strong> at the top of the column. The field names within one list must be unique. In the example below, the text “Annual Fee” is <\/strong>a field name.<\/p>\n\n\n\n A record<\/strong> is a row<\/strong> of data in the list. Each record is one item of data in the list. In the example below, the row of information for Fred Jackson<\/strong> is one record. Note that advanced filters do not work correctly if there are blank rows in the list.<\/p>\n\n\n Criteria<\/strong> are tests against the data in specific fields, for instance, Gold. When Gold is tested against the field Type, the filter displays only people with Gold<\/strong> memberships. All other records are filtered out (hidden).<\/p>\n\n\n\n The criteria range<\/strong> is the area where you specify the criteria. The first row contains the field names that mirror those in the list. The second and subsequent rows are used to type the criteria or examples of what you are looking for in the list.<\/p>\n\n\n\n If you want the conditions between fields joined with an AND<\/strong>, you write the conditions on the same row. If you want them joined with an OR<\/strong>, you write the conditions on separate rows. In the next example below, our criteria specifies greater than 15<\/strong> years membership AND Gold<\/strong> membership.<\/p>\n\n\nFields, Field Names and Records in Excel
<\/strong><\/h4>\n\n\n\n![\"Understanding](\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/07\/understanding-advanced-filters-excel-1.png\")
Criteria, Criteria Range, AND and OR in Excel
<\/strong><\/h4>\n\n\n\n
![\"Understanding](\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2017\/07\/understanding-advanced-filters-excel-2.png\")