Hello,

I have a table with data, it has a list of words in the table, there are about 25 different words in the column.

I want to produce a formula which gives me all the different words in that column in a table.

Secondly I want to count the frequency of those words in that column.

Does anyone know how.

Thank you in advace.