Ok, that works now for one type of text value

But now when I had more than one text value, it doesn't distinguish between
the text values.

For example, Cell G22 below should return a value of 2, but it's currently
returning a value of 4.

ColA | ColB | ColC | Col D | ColE | ColF | Col G|
Apples | Bears | Apples | | | | 4
Bears | Apples | | Apples | | | 2
| | | Bears |

thanks a lot...