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