Hi there,
I am trying to extract thefrequency of a certain abnormality (adenoma) out of multiple reports. The problem is that due to the pharsing in the reports ( ex. no adenoma found) I get false hits if I just look for the word adenoma in the cell. Is there a way to efficiently discern between these two? The database consist of 10k+ reports so I am unable to check them all manually.
I tried to use this formula someone on this forum was kind enough to send me, to find the frequency of mentions of no adenoma for example: =SUMPRODUCT(ISNUMBER(SEARCH("no* adenoma";TRIM(MID(SUBSTITUTE($B4;":";REPT(" ";LEN($B4)));(ROW($B$1:$B$10)-1)*LEN($B4);LEN($B4)))))+0)
This formula seems to work for simple one line answers in the sample worksheet at the time, but once I checked a sample of the complex reports it doesn't work anymore.
In the worksheet you will find fictive examples of reports in terms of pharsing.
Thanks for the help!
Bookmarks