Hello all,

I know how to determine wether a group of characters, or the content of one
cell, is present somewhere among the content of another cell. For instance
as follows:

If the group of characters I am searching for is in, say, cell C1 and I want
to know wether and how many times it occurs in cell A1 (possibly amidst
other content), I use

=(LEN(A1)-LEN(SUBSTITUTE(A1,C1,"")))/LEN(C1)

But now I want to look into a range of cells, say A1 to A25. These cells can
have complex contents, I just want to now how many times the content of C1
is present somewhere in the content of cells in the range. And as een
option: plus a list of the adresses of the cells that contain the content of
C1.

Your assistance will be appreciated.

Jack Sons
The Netherlands