Count If Similar

Daily Dose of Excel by Dick Kusleika http://www.dicks-blog.com/

=COUNTIF(A1,"DD???F*")

? acts a substitute for single characters, * acts a substitute for multiple characters



© Copyright 2004 - 2007, andrewsexceltips.com. All Rights Reserved.