Custom filter a column

[Thistledown]

I have 3000 records of sku's for the list range and a criteria range of 700 sku's for the custom filter. However the advanced filter function is not working for me because I need the filter to match if the criteria sku is either an exact match or only contained in the list range sku's. e.g. sku 10-015-YE should be returned if criteria sku is an exact match or just 10-015

[Special-K]

You also can filter data based on a specific substring with Custom AutoFilter in Excel. 1. Select the data range, and click Data > Filter. Then click at the arrow at right side of column header of which column you want to filter on, and click Text Filters or Number Filters > Contains.

Enter 10-015 as the "Contains value"