Welcome to exceltrainingvideos.com on youtube!
We have a set of colors as keywords and each keyword is assigned to a name of a person. On the other hand we have phrases containing the keywords. We have to extract the keywords from the given phrases, compare them with the given keywords and finally assign each phrase a name of a person depending on the keyword.
We could solve this problem using the nested do while loop along with the InStr function.
[ Ссылка ]
