Hi €“ are there any Excel gurus 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?

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

"Corina" <Corina @discussions.microsoft.com wrote in message
...
Hi €“ are there any Excel gurus 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?

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

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

--
Jacob


"Corina" wrote:

Hi €“ are there any Excel gurus 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?