Multiple Criteria Using Auto Filter

Originally Posted by royUK

You are limited to two criteria with AutoFilter, are all entries in one column?

It certainly is

Originally Posted by RichardSchollar

You could use Advanced Filter for this but note I frequently find Advanced Filter to be sloooooow especially on large data ranges.

Your criteria for the Advanced Filter could be along the lines of:

=ISNUMBER(MATCH(A2,{1,2,3,4,5},0))

where {1,2,3,4,5} represents your 5 values you want returned in the filter. eg is strings this would be {"String1","String2","String3","String4","String5"}.

Richard

I keep getting the error message: "Reference is not valid"

I have figured it out:

I have created a template file with my fields in row 1 and my criteria in row 2. I have then applied an advanced filter referencing the criteria range as the range in my template file. Works a treat.

Thanks

you could use vba.

Please Login or Register  to view this content.

not really sure what happens if one of the items is not on the list.

alsoe if you know how to make user forms you could make a shanzzy input form.