Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to search a block of text for presence and frequency of ter
for each cell in Range("A1:A10")
msgbox cell.value & ": " & application.Countif( _ Worksheets("Sheet1").Range("A1:Z200"),"*" & _ cell.Value & "*") Next Probably isn't the complete solution, but should give you some ideas. It counts how many cells contain the searched for string (but if a cell has it more than once, the cell is only counted once) -- Regards, Tom Ogilvy " wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two search category & two search terms | Excel Discussion (Misc queries) | |||
Search returning ans in terms of Rows & Columns | Excel Discussion (Misc queries) | |||
searching a large database with a long list of search terms | Excel Programming | |||
Search files, confirm presence | Excel Programming | |||
how to set up a vlookup table with 2 search terms? | Excel Worksheet Functions |