Hi All,

I'm looking for a function that can check to see if a cell contains
specific text. For Example:

I have many cell that contain some, all, or none of the following
4-character text:
|C180|, |D410|, |S531|, |T844|
and I would like to know if, let's say D410, is contained in a certain
cell. I will be checking for this in an array.

I also have another quick question. Is sumproduct or sum(if(.....))
quicker if they are both checking the same amount of criteria?

Thank you in advance,

Jason


--
jhockstr