I would like to use advance filter on a column with 4 character text entries. I want to see all entries that do not end with "RD". I can do this with the regular filter on, but I want to extract a list using the advance filter.

Make sure the column has a meaningful header in the first row. I have no idea what your data represesnts so let's say the header is Characters.

The criterion in the criteria range you would use is:

Characters
<>*RD


The * is a wildcard which represents any number of characters.

Hope that helps...

This worked perfectly. Thank you.

Hello,

you are going wrong you using only "RD" but actual code is " <>*RD "
And you have to also make sure to use * .

Good Luck!!!