TRUE If Similar

To get TRUE from a similar match

=IF(COUNTIF(A1,"An?*??")>0,TRUE)



© Copyright andrewsexceltips.net All Rights Reserved.