Forum Discussion
Solved
Find the frequency for how many times each unique word is listed
Hi, I have a list of text that is 10,372 rows. Using the formula: =COUNTA(UNIQUE(A2:A10376)) , I have found that there are 1672 unique words, and using the formula: =UNIQUE(A2:A10376) have a tex...
- The easiest method would be inserting a Pivot Table and then drag the Topics field in the Row area and drag the same Topics field again in the Values area. That would show you a report of all the unique Topics and their counts.
Thank you!
You're welcome!
If that takes care of your original question, please take a minute to accept the post with the proposed solution as the Best Response to mark your question as Solved.
If that takes care of your original question, please take a minute to accept the post with the proposed solution as the Best Response to mark your question as Solved.