(Solved) – Counting the number of words for every cell


How do i count the total number of specific words of each cells? For example under the header “alt/firstmap”, count the number of words “first” and the number of words “alt” in every cells and concentate them into a string with the total count for example “first -” & firstcounter(where firstcounter total count for first) like the one shown in column B while ignoring empty cells in the process?

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *