Is it possible to count different words?
If yes how is the formula?

Thanks!


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=507211

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 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:D8,D3:D8)=1)) returns 3

If you need something more specific, then be more specific with your question.

"Vic1978" wrote:


Is it possible to count different words?
If yes how is the formula?

Thanks!


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile: http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=507211