Counting similar text
 

Help! I'm stumped.

If column A is list of colours , with 100 text entries (rows) and the
word 'Green' appears randomly 32 times, Blue 41 times and Red 27 times.
What is the formulae that would produce the result of Green 32, Blue 41,
Red 27.

Garyadders - novice


--
garyadders
------------------------------------------------------------------------
garyadders's Profile: http://www.excelforum.com/member.php...o&userid=28691
View this thread: http://www.excelforum.com/showthread...hreadid=483781

Counting similar text
 

There is no such beast per see, you can combine 3 formulas and concatenate
them and add the commas like in

=greenformula&", "&blueformula&", "&redformula

--
Regards,

Peo Sjoblom

(No private emails please)


"garyadders" wrote
in message ...

Help! I'm stumped.

If column A is list of colours , with 100 text entries (rows) and the
word 'Green' appears randomly 32 times, Blue 41 times and Red 27 times.
What is the formulae that would produce the result of Green 32, Blue 41,
Red 27.

Garyadders - novice


--
garyadders
------------------------------------------------------------------------
garyadders's Profile:
http://www.excelforum.com/member.php...o&userid=28691
View this thread: http://www.excelforum.com/showthread...hreadid=483781

Counting similar text
 

=COUNTIF($A$1:$A$100,"*Red*")
=COUNTIF($A$1:$A$100,"*Green*")

or (a little fancier)

D1: Red
D2: Green

E1: =COUNTIF($A$1:$A$100,"*"&D1&"*")
E2: =COUNTIF($A$1:$A$100,"*"&D2&"*")

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=483781

Counting similar text
 

Ron your a star

Many Thanks

Regards Gary


--
garyadders
------------------------------------------------------------------------
garyadders's Profile: http://www.excelforum.com/member.php...o&userid=28691
View this thread: http://www.excelforum.com/showthread...hreadid=483781

Counting similar text
 

Thanks Peo

I forgot the comma's can be part of the code.

Regards Gary


--
garyadders
------------------------------------------------------------------------
garyadders's Profile: http://www.excelforum.com/member.php...o&userid=28691
View this thread: http://www.excelforum.com/showthread...hreadid=483781