[µo°Ý] ­pºâ¦h­ÓÀx¦s®æ¤¤¦³¥]§t¬Y­ÈªºÁ`¼Æ¡A¨ç¼Æ­n¦p¦ó³]??

´Ñ»y³¾»ï

¦p´£©Ò¥Ü:
¨Ò¦p:B1=Ä«ªG ­»¿¼ ªÝ¼Ö ¬h¤B ½¬Ãú ªJªI
       B2=½¬Ãú ªJªI
       B3=­»¿¼ ªÝ¼Ö ¬h¤B »ñ±ù
       B4=¬h¤B ½¬Ãú ªJªI
       B5=ºhåÑ ªÝ¼Ö ½¬Ãú ¬h¤B
       B6= ½¬Ãú ªJªI

¦pªG§Ú­nA2¤¤¨D¥XB1~B6¤¤"¥]§t"ªÝ¼ÖªºÀx¦s®æÁ`¦@¦³´X­Ó¡A½Ð°Ý¦bA2ªº¨ç¼Æ­n¦p¦ó³]??
°²³]:A1=ªÝ¼Ö
     A2= 3(B1~B6¤¤Á`¦@3­ÓÀx¦s®æ¦³ªÝ¼Ö)

Hsieh

¯Â°Q½×
°}¦C¤½¦¡
=MAX(IF(SUBSTITUTE(B1,A1,"",ROW(1:10))<>B1,ROW(1:10),""))

chin15

=(LEN(B1)-LEN(SUBSTITUTE(B1,A1,"")))/LEN(A1)
¥ýÄm­Ó¤¡¡Aµ¥ª©¥D§ó¦nªº¤½¦¡

´Ñ»y³¾»ï

¦^´_ 3# Hsieh


    ¦b½Ð°Ý¤@¤U¡A¦pªGB1~B6³£¦b¦P¤@Àx¦s®æ¤¤¡A­n¦p¦ó¨D¥XA1(ªÝ¼Ö)ªºÁ`"¥X²{¦¸¼Æ"

Hsieh

=SUMPRODUCT(ISNUMBER(FIND(A1,B1:B6))*1)

chin15

=COUNTIF(B1:B6,"*"&A1&"*")