Comparing with wildcard values

  • Thread starter Thread starter Zargon_osu
  • Start date Start date
Z

Zargon_osu

I need a logical test between a cell and a sting that includes wildcard
values. For instance:

return 1 when comparing AA10-14 to AA*10* where the stars are
wildcard for any number of any characters
but 0 when comparing AA11-13 to AA*10*, etc

Is there a function that does this? Most functions like EXACT and just
logial "=" dont accept wildcard values.

Thanks
 
Back
Top