Match If Similar
To find an entry starting with C (non-case sensitive)
=MATCH("C*",A1:A10,0)
?
acts a substitute for single characters,
*
acts a substitute for multiple characters
© Copyright
andrewsexceltips.net
All Rights Reserved.