Advanced Filtering

[Corina]

Hi – are there any Excel guru’s out there who can help me with advanced
filtering? I need to find rows that ‘contain’ the value in my criteria range
not that ‘equal’ it….does anyone know if this can be done?

 

[Fred Smith]

Look in Custom Filter... One of the options is "contains".

If you need more help, post back with the version of Excel you are using.

Regards,
Fred

 

[Jacob Skaria]

Check out 'Create a Custom Filter' in the below link

http://www.contextures.com/xlautofilter01.html