How Do You Create Criteria Ranges In Excel For Database Functions?
You can analyze the data in a Microsoft Excel spreadsheet by using database functions, which are a series of calculations. Before you perform a new database function you must establish the criteria, which are a range of cells in your spreadsheet that contain specific rules for how you want your data to be evaluated. Using the Filter features in Excel you can create the criteria, which can include rules for a function to only include values containing a certain number, numbers that match each other or numbers that are greater to or equal to a specific number. Open the Excel application on your computer that contains the table of database functions that you want to create criteria for. Highlight the range of cells containing numeric data using your mouse. Click on the “Data” tab for Excel 2007 or the “Data” option from the top toolbar menu for Excel 2003. Click on the “Filter” option and the click on the drop-down arrow located in the column header. Move your mouse over the “Number Filte