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.