I have events in column 1,in my sheet there are about 800 events.
In col 2. each contestant has a label,blue(b),green(g) or red(r)
In column 3 I want to print the number of non reds in each event,in my
attached file this is 7,4 and 4 respectively--I need a formula to fill
down column 3 to do this automatically.


+-------------------------------------------------------------------+
|Filename: 3 letters.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5184 |
+-------------------------------------------------------------------+

--
pytelium
------------------------------------------------------------------------
pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521
View this thread: http://www.excelforum.com/showthread...hreadid=571163