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