Prev: How to see full path name of open workbook?
Next: How do I get a total
From: Corina Corina on 18 Mar 2010 01:10
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?

From: Fred Smith on 18 Mar 2010 01:17
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
news:F646ADDB-3E98-4482-AE32-BE459E56012E(a)microsoft.com...
> 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?
>

From: Jacob Skaria on 18 Mar 2010 02:28
Check out 'Create a Custom Filter' in the below link

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

--
Jacob


"Corina" wrote:

> 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?
>
 | 
Pages: 1
Prev: How to see full path name of open workbook?
Next: How do I get a total