How to use And and Or operators with Excel’s Advanced Filter Your email has been sent Editor’s Note: This article was originally published in July 2010 and the video tutorial for this article ...
Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data matching your specified criteria.