Forum Discussion

Edmund Kong's avatar
Edmund Kong
Copper Contributor
Mar 11, 2018

Counting frequency which text appears in column

I have a column of ~1000 entries of text values and empty cells.

I want a formula to calculate the frequency of every text value in the column. So the answer should be displayed in two columns. First column should be the text value and 2nd column should be the frequency of occurrence.

 

Any help is much appreciated.

excel
Formulas and Functions

3 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Mar 12, 2018

    Hello Edmund,

     

    Please find the attached file to see an example of what you are asking for.

    It's done by using https://support.office.com/en-us/article/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34?ui=en-US&rs=en-US&ad=US.

     

    Hope that helps
    Haytham

Resources