Trying to search a block of text for presence and frequency of terms in Excel
The problem:
I have a list of text terms and phrases in an Excel spreadsheet. I
want to check large blocks of text (paragraphs, essays, etc.) for the
presence and the frequency of these terms and phrases. Can someone
please suggest the easiest or best route? Should I be looking into SQL
and indexing functions here?
Thanks!
|