![]() ![]() This filtering task has two requirements - two criteria - and you want to satisfy them both. Now, suppose you wanted to know which products with a price of $20 or more have 10 or less units currently in stock. (To remove a filter, simply choose All from the same list.) It's quick and easy, but sometimes inadequate. Using this feature, you can perform simple filtering tasks, such as which products have no units on order. Excel will display a dropdown arrow for each column in the selection. In Excel 20, click the Data menu and then click Filter in the Sort & Filter group. To apply an AutoFilter, you select the column headings in A1:F1 and choose AutoFilter from the Data menu. Before we get into a more advanced example, let's look at a simple AutoFilter example using a partial set of data from the Products table from Northwind (the database that comes with Access). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |