You are absolutely right, it was the spaces. This one should work for you

=SUMPRODUCT(--ISNUMBER(FIND(MID(SUBSTITUTE(B2," ",""),
FIND("~",SUBSTITUTE(","&SUBSTITUTE(B2,"
","")&",",",","~",ROW(INDIRECT("1:"&C2)))),
FIND("~",SUBSTITUTE(","&SUBSTITUTE(B2,"
","")&",",",","~",ROW(INDIRECT("2:"&C2+1))))-
FIND("~",SUBSTITUTE(","&SUBSTITUTE(B2,"
","")&",",",","~",ROW(INDIRECT("1:"&C2))))-1),A2)))

I tested with your data and go tthe results you predicted (bar 2, which are
mistakes on your part I think :-))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sun1x" wrote in
message ...

I do not know how to post the file to you, I attach the file here, once
you download it, change the file name extension to .xls

Thanks


+-------------------------------------------------------------------+
|Filename: Sample.txt |
|Download: http://www.excelforum.com/attachment.php?postid=3952 |
+-------------------------------------------------------------------+

--
sun1x
------------------------------------------------------------------------
sun1x's Profile:
http://www.excelforum.com/member.php...o&userid=28327
View this thread: http://www.excelforum.com/showthread...hreadid=479096