How do I count how many times each text appears in a column? For example I have this column:
foo1 foo1 foo1 too2 foo1 too2 mmm mmm foo1
Now I like to excute a function that shows me this result:
foo1 = 4 mmm= 2 too2 =2
Can this be done in a single advanced function?
i did try with COUNTIF but then i need to do on each text instance.
but then i need to know which text's i have in each column. what i want is function that will take the column and calculate each text how many instances it has in the column