A data tool that filters lists using complex criteria defined in a separate range, with the option to extract results to a new location.
Probeer het met AIAdvanced Filter allows for more complex filtering logic than standard AutoFilter, such as using 'OR' conditions or calculated criteria. It requires a criteria range set up on the worksheet, and users can choose to filter the list in place or copy the filtered rows to another location.
To find all sales records where the 'Region' is 'North' OR the 'Amount' is greater than 5000, you define these headers and values in a separate range and point the Advanced Filter tool to that range.
AutoFilter is limited to simple column-based selections, whereas Advanced Filter supports complex logic, multiple 'OR' conditions, and the ability to copy results to a different sheet.