Using AdvancedFilter, I would like to match fields whose text values
END with a specific character. For example, I'd like *o to match
'hippo', 'banjo', but NOT 'support'. Currently, when I apply the *o
criterion, I get results that include all fields with an 'o' in any
character position.

Can someone please show me how to restrict the match to the end of the
string only?

One caveat: I imagine this may require use of a formula criterion,
rather than the more simple form using column headings in the criteria
range. But if it's possible to accomplish this both ways, could you
please describe them both?

Thanks very much,
Bruce Reid

Can you use Autofilter?

You can specify "Ends with" 0 under the custom option.

But if you have to use advanced filter, this criteria worked ok for me:

HeaderHere
="=*o"



bereid wrote:

Using AdvancedFilter, I would like to match fields whose text values
END with a specific character. For example, I'd like *o to match
'hippo', 'banjo', but NOT 'support'. Currently, when I apply the *o
criterion, I get results that include all fields with an 'o' in any
character position.

Can someone please show me how to restrict the match to the end of the
string only?

One caveat: I imagine this may require use of a formula criterion,
rather than the more simple form using column headings in the criteria
range. But if it's possible to accomplish this both ways, could you
please describe them both?

Thanks very much,
Bruce Reid

--

Dave Peterson

Dave, this worked beautifully!! Thank you very much for the great (and
quick) response.