how to get keywords in excel?

By suom ·
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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Complex question

by robo_dev In reply to how to get keywords in ex ...

So in effect you want to query and sort based on the number of times the query finds a word? Sounds like a tricky homework assignment to me, but here goes:

how to count occurences of text string:

So logically, you would need to:

map the text (not sure what you mean by that)
to a particular row, based on results of the text string counting logic, thus a row in the range where basketball = 3 would get the text mapped to it.

Not sure if all this is helpful or not...

Related Discussions

Related Forums