Use advanced filters in excel for mac5/11/2023 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. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |