I’ve create a simple list of keywords in a table with a single column.
The aim of the project is to have a table where I can input as much text as I want into a row and see which keywords are contained in that text and the total number of keywords in that text.
I have another table that contains three columns - #1. Text // #2. Number of Keywords in Text // #3. Keywords in Text
I am unable to figure out how to write the formula to aggregate and count outputs #2 and #3.
Here is the working example.
Thanks in advance for any guidance,