formula to count multiple values in one column
I have a long column that contains over 1000 values and I want to count how many times the values appear. I tried to use the countif formula but it is not working as the values are sentences and there are over 85 different sentences, which makes it hard to capture each sentence in a formula. Could you please help me find the best way to capture this information?
Looking forward for your help!
Help Article Resources
Check out the Formula Handbook template!