On Wed, 13 Apr 2011 15:57:06 -0700 (PDT), kittronald wrote:

Ron,

That'll do it.

My computer is a bit slow with array entered formulas and given the
number of cells this would run in, the calculation time would be quite
mind numbing.

Thanks again.



- Ronald K.

If speed is a significant issue, you could also try:

=SUMPRODUCT(COUNTIF(A1,"=*"&WordList&"*"))0

With just two functions, vs 3 in the previous, it might execute faster.