TRUE If Similar
To get TRUE from a similar match
=IF(COUNTIF(A1,"An?*??")>0,TRUE)
© Copyright 2004 - 2010,
andrewsexceltips.net
All Rights Reserved.