I am using advanced filter in Ex2002 to filter a list of strings based on a
string criteria. The problem is that Excel does not match strings exactly,
it also returns longer strings where the criteria is a sub-string. I.e., if
the list is

"AAA"
"AA"
"A"

and the criteria is "A", it will return all 3 entries instead of one.

Is there any way to force excel to filter by exact match?

Thanks!

RADO