Using the Custom Filter Function in Excel

**davey11372** · 02-03-2010, 07:21 PM

I am trying to use the AutoFilter/Custom function in Excel (it is available under the Data Menu). It offers me two conditions/criteria that I can apply using and/or. For eg:

Filter:

does not begin with - 3

and / or

does not begin with - 9.

I want to add a third 'and' criteria .. is it possible, and if so, how?

The column that I am trying to filter has numbers formatted as text.

**martindwilson** · 02-03-2010, 08:10 PM

your example doesn't have anything that has -3 or -9 in it! ,(or just 3,9 not sure if you meant to include -)
just 3 columns
with dates col I
times col J
an some values in col K

**davey11372** · 02-03-2010, 09:17 PM

The sheet was only a sample, I wanted a general answer to the question.

On this particular sheet I am trying to use it on column J, which inlcudes time stated as a text value. I want to exclude/filter all cells.rows that have the time value beginning with 3, 9, 4.

I hope this will clarify the question.

**Andy Pope** · 02-04-2010, 08:48 AM

One way would be to add a helper column.
Use a formula to flag the rows requried.

In column L use, and then filter L on #N/A
=VLOOKUP(LEFT(TRIM(J2),1),{"1";"4";"9"},1,FALSE)