• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Counting undefined Text in a column

Good evening RanjanSatya


To count specific words


=COUNTIF(A1:A10,"Travel")


To count all cells with text


=COUNTA(A1:A10)
 
Thank you for your response Bobhc


Am sure this worrks on Specific words


I want to count undefined words


Am not sure if there is a word called "Travel" in that column
 
RanjanSatya


The first example was to show how to count specific words, in this example "Travel" which would be changed to suit the word to look for.


I think you want the second example to count all the words in a column.
 
but am not sure what words that column may have

Usually i run a pivot table and take count of each word. was checking to see if there is any formula that i can use
 
RanjanSatya


I am of the understanding you want to count the number of words in a column as your first post. The second example, =COUNTA(A1:A10), just alter the range to suit. ☺
 
Ditto to what shrivallabha. Also, if you search these forums for "unique count" you'll find several other threads with helpful formulas.
 
You must log in or register to reply here.
Back
Top