Advanced filter without extra data

Topic

New Reply

Hello.
I’ve created a procedure to place the active cell text into a criteria range and then use Advanced Filter with this criteria. The text is correctly placed in the cell, but the Advanced Filter process treats the criteria as though it were >=ALPHA rather than just ALPHA. How can I force it to just find precise matches to ALPHA?
Thanks, Andy.

Reply | Quote

Replies

Can you attach a sample workbook?

Reply | Quote

Can you attach a sample workbook?

Thanks for your response. I managed to resolve this by creating a calculated criteria that uses ‘=D9=”ALPHA”‘. I assume this is a microsoft bug/feature as it should work with a simple criteria ‘ALPHA’. Andy.

Reply | Quote

Both Advanced Filter and the database functions (e.g. DSUM) treat naked text (e.g. “Cat”) in the criteria fields as if there were wildcards.
“Cat” returns the same as “=Cat*”.

I suspect that it comes from a blank in the criteria field, being treated as ALL. “” is the same as “=*”

Reply | Quote

If you want an exact match, you need to use a criterion like:
=”=my value”
in the criteria range.

Reply | Quote