Hi TudyBTH
Thanks for the idea but I seem to be still encountering a problem with that formula you suggested it worked for a limited amount of data but the more data was added the more it began to produce odd results. I suppose the true purpose of this problem is to seek if there is a relative method to have two lists in which list 1(groups) match against the relevant words in list 2(words)....I have a VERY large list and was wondering if there could be a solution for this. I provided an example within this post.
Bookmarks