V
Vic1978
Is it possible to count different words?
If yes how is the formula?
Thanks
If yes how is the formula?
Thanks
D
Dave O
It is possible, but the solution depends on one or two things. Suppose
you're looking for the word "blue": will the cells in question contain
*just* the word blue, or might it be contained in a text string such as
"the sky is blue"? Do you want to count a handful of words, and if
yes, do you mind counting one at a time or do you need to count them
all at once (for instance, count red, white, and blue in separate
formulas, or all in one formula)?
you're looking for the word "blue": will the cells in question contain
*just* the word blue, or might it be contained in a text string such as
"the sky is blue"? Do you want to count a handful of words, and if
yes, do you mind counting one at a time or do you need to count them
all at once (for instance, count red, white, and blue in separate
formulas, or all in one formula)?
S
Sloth
You can use the COUNTIF function to count specific words
You can use SUMPPRODUCT to count unique words
Example:
A1 the
A2 boy
A3 ran
A4 fast
A5 boy
A6 =COUNTIF(A1:A5,A1) returns 1
A7 =COUNTIF(A1:A5,"boy") returns 2
A8 =SUMPRODUCT(--(COUNTIF(D3
8,D38)=1)) returns 3
If you need something more specific, then be more specific with your question.
You can use SUMPPRODUCT to count unique words
Example:
A1 the
A2 boy
A3 ran
A4 fast
A5 boy
A6 =COUNTIF(A1:A5,A1) returns 1
A7 =COUNTIF(A1:A5,"boy") returns 2
A8 =SUMPRODUCT(--(COUNTIF(D3
8,D38)=1)) returns 3If you need something more specific, then be more specific with your question.