Forum Discussion

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
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.

Lorenzo

Silver Contributor

Jul 06, 2021

HelpGeorge

Alternatively, with data in A1:A15

in C1:

=LET(
    range,  A1:A15,
    unique, UNIQUE(range),
    CHOOSE({1;2}, unique, COUNTIF(range,unique))
)