Mar 11 2018 02:15 PM
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.
Mar 11 2018 08:08 PM
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
Sep 10 2021 12:27 AM
Sep 10 2021 03:37 AM