Forum Discussion
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. Fir...
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
Where is the attached file?
