How to use AdvancedFilter wildcard to match end of string?

[bereid]

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]

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]

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