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?