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

­pºâ¥X³f¦¸¼Æ

­pºâ¥X³f¦¸¼Æ

¦U¦ì¤j¤j¦n:

½Ð±Ð¦p¤U:
¥Hsheet "¥X³f"ªºDÄæ "¥X³f³æ¸¹"¬°¥D(DÄæ¦P¤@­Ó¸¹½X·í¦¨¤@¦¸¥X³f),¦bsheet "BCM"ªºBÄ椤¥H¤½¦¡±a¥X¥¿½Tªº¥X³f¦¸¼Æ.
­pºâ¥X³f¦¸¼Æ.zip (7.45 KB)

¦^´_ 1# PJChen


    =COUNT(1/N(MATCH(A2&¥X³f!D$2:D$100,¥X³f!B$2:B$100&¥X³f!D$2:D$100,)=ROW(A$1:A$100)))

°}¦C¦¡
(CTRL+ SHIFT+ENTER)

TOP

¦^´_ 2# man65boy

½Ð°Ý¦³¨S¦³¤£­n¥Î°}¦Cªº¤èªk,§Ú©ÒÁ|ªº¥u¬O¨ä¤¤¤@¦C,¥­®Éªº¤u§@ªí¦]¬°¨C¤Ñ³£·|¼W¥[¸ê®Æ,¥Î°}¦C¬O§_·|¤£¤Ó¦X§Ú¥Î?

TOP

­Y¼Æ¾Ú°Ï±`·|ÅÜ°Ê¡A«Øij«Ø¥ß°ÊºA¦WºÙ¡A¤@³Ò¥Ã¶h¡A¥ç¥iÁYµu¤½¦¡
­pºâ¥X³f¦¸¼Æ.rar (8.25 KB)

TOP

¦^´_ 4# oobird
¬Ý¨Ó©w¸q¦WºÙ½T¹ê¤½¦¡¤ñ¸ûºë²,¦ý§Ú¹ï³o¤è­±¤£¼ô,¬Ý¨Ó­n¥ý¬ã¨s¤@¤U,¤£¹L·Qª¾¹D­Y¤£¥Î©w¸q¦WºÙ¤S¤£¥Î°}¦C,¥i¦³¾A¥Îªº¤½¦¡?

TOP

¦^´_ 5# PJChen


    ¥i¥H¥Î¼Ï¯Ãªº¤è¦¡¥[¤W¤@¨Ç²³æªº¤½¦¡¤]¥i¥H¹F¨ì§A»Ý­nªº®ÄªG~
     ¥ÎÂù¼Ï¯Ã¤è¦¡+¨ç¼Æ ÂX¥R©Ê¥ç«Ü¤è«K~ ´£¨Ñ¥t¤@ºØ³B²z¤è¦¡µ¹§A°Ñ¦Ò
   

    ¦pªG­n¥Î³æ¤@­ÓÀx¦s®æ¨Ó³B²z~ ´N¥Î¤W­±¨â­Ó¤j¤jªº¤è¦¡~
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD