Counting frequency which text appears in column

%3CLINGO-SUB%20id%3D%22lingo-sub-170283%22%20slang%3D%22en-US%22%3ECounting%20frequency%20which%20text%20appears%20in%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-170283%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%20~1000%20entries%20of%20text%20values%20and%20empty%20cells.%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EI%20want%20a%20formula%20to%20calculate%20the%20frequency%20of%20every%20text%20value%20in%20the%20column.%20So%20the%20answer%20should%20be%20displayed%20in%20two%20columns.%20First%20column%20should%20be%20the%20text%20value%20and%202nd%20column%20should%20be%20the%20frequency%20of%20occurrence.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EAny%20help%20is%20much%20appreciated.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-170283%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-170330%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20frequency%20which%20text%20appears%20in%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-170330%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Edmund%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20find%20the%20attached%20file%20to%20see%20an%20example%20of%20what%20you%20are%20asking%20for.%3C%2FP%3E%0A%3CP%3EIt's%20done%20by%26nbsp%3Busing%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcountif-function-e0de10c6-f885-4e71-abb4-1f464816df34%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECOUNTIF%20function%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that%20helps%3CBR%20%2F%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

3 Replies

Hello Edmund,

 

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

It's done by using COUNTIF function.

 

Hope that helps
Haytham

Where is the attached file?

@Z Z 

=COUNTIF(A2:A1000,"Your Text")

=COUNTIF(A2:A1000,C2)