Hi,

I have a problem with Countif, and that is it seems to only work where the
criteria is 255 characters or less.

I have concatenated about 30 columns of data into the next available column
and wanted to use that column as the range and each cell within the range as
the criteria. Some of the concatenated cells have up to 400 characters in
them and anything over 255 characters is giving me a result of #VALUE!.

Is there some other function that might enable this?
--
Regards,
Booey