How to Access Query Criteria from Excel
- 1). Launch your Excel software on your computer. Go to the Excel file from which you intend to access query criteria.
- 2). Design a new empty row directly above the particular range you desire to query. Right-click your mouse on the upper row of the information, and then select the "Insert" option.
- 3). Enter your query criteria in the cells of your empty row. For instance, if you intend to work with a list of fees and want to query just the items that have fees greater than $15, enter ">15" in your empty cell directly above your fee column.
- 4). Go to "Data" and then click on the "Filter" option. Click on "Advanced Filter."
- 5). Click in the box for every range ,and then drag your mouse over the cells that make up the field to let Excel know the exact ranges for the information and criteria. Click "Enter" to complete the process.
Source...