NOTE: With a filtered "in-place" database, the row numbers will turn blue. In the Criteria range field, type the range of cells or the range name containing the criteria.To minimize the Advanced Filter dialog box so you can select the range of cells manually, In the List range text box, type the range of cells containing your database.NOTE: If you do not want the filter to replace the current database, refer to Copying an Advanced Filter to a Second Location below.
If you want the filter to replace the current database, select Filter the list, in-place. NOTE: For more information, refer to Establishing Criteria.įrom the Data menu, select Filter » Advanced Filter. Running an Advanced FilterĬreate a criteria range within your worksheet. As a precaution, you may want to place the placement headings on a separate sheet in the workbook file. WARNING: If there is any information under the headings for the placement location, it will be deleted.
#Advanced excel for mac registration#
For example, you may have a large database of conference attendees and want to filter only the attendees' names and whether their registration fee has been paid and send that data to another sheet in your workbook. You do not need to include all the headings of the original database and the headings that you do use can be in a different order. For examples of which criteria may be used, refer to Establishing Criteria.Įstablishing a Placement Location (optional)Ī placement location is a row with column headings for the types of information you want to place in a different location. Additionally, at least one blank row must be between the criteria range and your database. The other row(s) contains your filtering condition.
The first row must contain a column label(s). Before You StartĪ criteria range consists of at least two rows. For example, it allows you to filter using complex "and/or" criteria. Advanced Filter has advantages not offered by the AutoFilter command. It also allows you to place the results onto a new worksheet so that you can overcome the problems of using certain features of Excel (printing, formatting, and editing options) while your database is filtered. The Advanced Filter command allows you to extract the records in your database based on a criterion and then move the results to a different location on the current worksheet. NOTE: AutoFilter is active if a checked box appears before it it is inactive if no checked box is present. NOTE: When you use AutoFilter within a database, the row numbers will turn blue. (Optional) If you want multiple criteria, select either And or Or and repeat steps 3 and 4. The Custom AutoFilter dialog box appears.įrom the Comparison Operator pull-down menu, select a type of comparison.įrom the Corresponding pull-down menu, select or type a criteria value. NOTE: When you use AutoFilter within a database, the row numbers will turn blue, and the results of the filter will appear in the status bar (e.g., 1 of 12 records found).Ī custom filter allows you to select a "range" of information or set multiple criteria.įrom the appropriate pull-down menu, select (Custom Filter… ). Rows meeting the filter criteria are now displayed. Activating AutoFilterįrom the Data menu, select Filter » AutoFilter.Ī pull-down menu will be placed next to each column heading within the selected database.įrom the appropriate pull-down menu, select a value to use as filter criteria. These menus are used to select the field contents, which determine what records will display. The AutoFilter command applies pull-down menus directly to the column headings in the database.
#Advanced excel for mac mac#
(Archives) Microsoft Excel 2007: Filtering Your Database Mac
0 kommentar(er)
