ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¸ê®ÆÂà¶K«á¦p¦ó¿z¿ï¨Ã­p¼Æ

¦^´_ 1# goudy

¦p¹Ï
F2=SUMPRODUCT(ISNUMBER(FIND($E2,A$1:A$3))*1)
¦V¤U¦V¥k½Æ»s

¥¼©R¦W.png (53.06 KB)

¥¼©R¦W.png

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-10-25 00:09 ½s¿è

¦^´_ 3# goudy


    ©Ò¥H±Ð§A¥Î¸ê®Æ­åªR§â¥¦¤À¦¨2Äæ
¦pªG¯uªº¤£·|­åªR
=SUMPRODUCT(ISNUMBER(FIND($E2,MID($A$1:$A$3,1,FIND("-",$A$1:$A$3))))*1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD