Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

Additionally, Advanced Filter enables you to copy the filtered data to a specified area within the same worksheet or a different worksheet rather than just filter the data within the original data ...

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.