Hsieh

E2=SUMPRODUCT(ISNUMBER(FIND($D2,OFFSET($A$1,,,COUNTA($A:$A),)))*1)

Hsieh

¦^´_ 3# oobird


    À³¸Ó«ÜºG

Hsieh

¦^´_ 5# °¶ÔÐ

¯à¦³³o»ò¦nªº³t«×¶Ü?
³oÀ³¸Ó¬O¥u§PÂ_FIND¦r¦ê¬O§_¦s¦b
©Ò¥H¨C­Ó°ê¦W¥u»Ý°µ7¤d¦h¦¸§PÂ_
¥i¨£¤º«Ø°}¦C¨ç¼Æ¹BºâÀ³¸ÓÂõۤñVBA§ó§C¶¥ªº»y¨¥

Hsieh

=SUMPRODUCT(ISNUMBER(FIND($D2,OFFSET($A$1,,,COUNTA($A:$A),)))*1)-(SUMPRODUCT(ISNUMBER(FIND($D2,OFFSET($D$1,,,COUNTA($D:$D),)))*1)-1)

Hsieh

¦^´_ 10# °¶ÔÐ
³o¤½¦¡½T¹ê¦³º|¬}
¦pªGDÄ檺°ê§O¦bAÄ椣¥u¥X²{¤@¦¸´N¥X¿ù¤F
¦A·Q·Q¬Ý°£¤FVBAÁÙ¦³¨ä¥L¬Æ»ò¤èªk¥i¥H§¹¥þ¤ñ¹ï

Hsieh

991002-1.rar (12.95 KB)

¤U¸ü¦¸¼Æ: 6

2010-10-3 00:45

©w¸q¦WºÙx=OFFSET(Sheet2!$A$1,,,COUNTA(Sheet2!$A:$A))
°}¦C¤½¦¡{=SUM(IF((LEFT(SUBSTITUTE(x,D2,""))=";")+(RIGHT(SUBSTITUTE(x,D2,""),2)="; ")+(ISNUMBER(FIND("; ;",(SUBSTITUTE(x,D2,"")))))+(SUBSTITUTE(x,D2,"")=""),1,0))}