http://www.vbaexpress.com/forum/showthread.php?t=43601

with the above link, it only picks up the first instance of the occurance of the word. I am wondering if the formula can pick up all / mutiple instances of the words inside the array.

if the sentence is:
- blue blue - pick up both (not just one blue, the first occurance)
- blue black - pick up both