Forum Discussion
Counting the number of occurrences of an entity in a table
I am trying to automate the counting of the number of times a country appears in a table. See below example. This table is original. ...
A solution for the future:
=LET(
all, TEXTSPLIT(TEXTJOIN(", ", , countries), , ", "),
GROUPBY(all, all, COUNTA)
)Thanks for your reply, but when I use your formula all I get is "#NAME?". I am probably entering the formula incorrectly or do not understand how to define the search area or where the results are to be listed. Sorry.