You type the advanced criteria in a separate criteria range on the worksheet and above the range of cells or table that you want to filter. It displays the Advanced Filter dialog box instead of the AutoFilter menu. The Advanced command works differently from the Filter command in several important ways. Salesperson = a name with 'u' as the second letter (Salesperson = "Buchanan" AND Sales > 1500) Multiple sets of criteria, one column in all sets Type = "Produce" OR Salesperson = "Buchanan" Multiple criteria, multiple columns, any criteria true Multiple criteria, multiple columns, all criteria true Salesperson = "Davolio" OR Salesperson = "Buchanan" Multiple criteria, one column, any criteria true To open the Advanced Filter dialog box, click Data > Advanced. If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box.
0 Comments
Leave a Reply. |