Problem using countif to find second contact in the same field....

Options

I have a column where I can add contacts from our integrated address list.

When I use "countif" to count the number of times a contact appears in the column, it works fine if only one contact is listed in the fields in the column.

If I add a second contact to some of the fields in the column and try to use "countif" to count those second contacts, it returns a "0".

For instance if the field contains "John Doe, Jane Doe", the countif can be used to count the number times of John Doe appears in the column, but a similar countif looking for "Jane Doe" returns a "0", even though the second contact is separated by a comma.

Any ideas welcome.....

Answers