Excel, How to count keywords between dates

In excel, I am looking for a way to count keywords between specific dates.

In column A, I have bunch of sentences that are mentioned in corresponding dates in column B.

For example,

Sentences Date
Apple is delicious 4/1/2021
Banana is delicious 4/1/2021
Grape is delicious 4/1/2021
Apple is delicious 4/1/2021
Banana is delicious 4/2/2021
Orange is delicious 4/3/2021
Banana is delicious 4/3/2021

I have tried using =SUMPRODUCT(--ISNUMBER(SEARCH("tsla",A2:A8)))) but I know it's wrong since there are different number of rows for each date.

As a result, I am looking for on this date, this keyword was mentioned n times and this keyword was mentioned n times and so forth.

Please look at attached image for example. enter image description here



Read more here: https://stackoverflow.com/questions/66998134/excel-how-to-count-keywords-between-dates

Content Attribution

This content was originally published by Do Hwan Kim at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: