Hi there,
Im having a problem with finding keywords in excel. Currently I have a table with a list of discipline words and keywords relative to them, e.g. sport: soccer, swimming, basketball. I am using this tool in order to map text I put into a table with relative disciplines. The problem right now though is that I want to map the text to the discipline with the most key words relative to the text but currently the disciplines at the top of the list have priority even if there is only one keyword in the text and another discipline word further down the list has three.
The code that im using is quite long but here is a sample of it: =IF(OR(ISNUMBER(SEARCH(D$2,A2),C$11,””)
If somebody could help me with this that would be great.
Cheers