Advanced Filter

[Zac]

I've never used the Advanced Filter feature.

I tried it today thinking it would work similar to the regular Data Filter, but I haven't had any luck yet.

My Data range (simplified) is A2:R100.
In COl "N" is my Dwg Rev Column. Letters range from A:W.
I am trying to filter only the letters A, H, and M, so that only those rows will show. No luck yet.

I've tried using ="A"="H"="M" ="A"OR"H"OR"M"

Any suggestions.

 

[brian.wethington]

First have you looked up advanced filtering in help?

It exalains that you will have criteria in a cell that is typed like so:

="=M"

Also, you will want some space in Rows 1:3 to put your filtering criteria.

 

[Norie]

Put Dwg Rev in the header and A, H and M in the rows below.

Then use that for the criteria.