Forum Discussion

HelpGeorge's avatar
HelpGeorge
Copper Contributor
Jul 06, 2021
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...
BI & Data Analysis
excel
Formulas and Functions
  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Jul 06, 2021
    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.
Marcia1720's avatar
Marcia1720
Copper Contributor
Jul 06, 2021
=COUNTIF(A$2:A$10376,C3) copy formula downn
Or: Try Pivot Table
  • HelpGeorge's avatar
    HelpGeorge
    Copper Contributor
    Jul 06, 2021
    Thank you!
    • Subodh_Tiwari_sktneer's avatar
      Subodh_Tiwari_sktneer
      Silver Contributor
      Jul 06, 2021
      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.

Resources