View Single Post
  #1   Report Post  
garyadders
 
Posts: n/a
Default 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