E.g.
- | boy | - no indication because there is only one new value that previously wasn't contained in the spreadsheet
- | the boy | - no indication
- | the boy sings | - no indication
- | the boy sings at night | - indication of some sort because both "at" and "night" were not previously contained in the spreadsheet.
I assume the indication would either be a highlighting of the row or the row next to it displaying a count.
Got answered on reddit from user 6745408
You'll need two formulas
For
A1For
A2on..The second one is long, but we need to strip out all of the previous lines so we can count the new words.