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

¤ñ¹ï¹ï·Óªí¸ê®Æ¡Aµù©ú"²Å¦X"

¤ñ¹ï¹ï·Óªí¸ê®Æ¡Aµù©ú"²Å¦X"

¥u­nBÄæ¹ïÀ³¨ìAÄ榳²Å¦XE¤ÎFÄ檺¹ï·Óªí¡A¦bCÄ椺µù©ú"²Å¦X"
¨Ò¦p¡G
BÄ椺4476.1511¡A¹ïÀ³ªºAÄ榳GO¡A¦bCÄæµù©ú"²Å¦X"

¬¡­¶Ã¯4.zip (12.26 KB)

joyce

¦^´_ 1# leiru

C2 =IFERROR(IF(INDEX(F:F,MATCH(B2,E:E,))=A2,"²Å¦X",""),"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089


    ML¤j®v,ÁÂÁ±z¦^ÂÐ,µª®×¤£¹ï.
·íFÄ榳¨â­Ó¥N½X®É,BÄæ´N­n¥h§äAÄ檺¨â­Ó¥N½X,¦A¼Ð¥Ü"²Å¦X",¨Ò¦p:C33,C35,C155,C239­n¼Ð¥Ü"²Å¦X"
¥t¥~,·Q½Ð±Ð¤j®v¥t¤@°ÝÃD¡GBÄæ²Å¦XEÄæ,«hAÄæ¦ÜCÄæ¥Îºñ¦â¶ñº¡
joyce

TOP

¦^´_ 3# leiru


    =IFERROR(IF(FIND(A2,INDEX(F:F,MATCH(B2,E:E,))),"²Å¦X",""),"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089


    ÁÂÁ±z,µª®×¹ï.
¦A½Ð±Ð¤j®v¥t¤@°ÝÃD¡GBÄæ²Å¦XEÄæ,«hAÄæ¦ÜCÄæ¥Îºñ¦â¶ñº¡
joyce

TOP

¦^´_ 5# leiru


A:CÄæ¿ï¨ú
³]©w®æ¦¡¤Æ±ø¥ó ¤½¦¡
=MATCH($B1,$E:$E,)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089


    ÁÂÁÂ
joyce

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD