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

[µo°Ý] ²Å¦X©Ò»Ý¥N½X «e¨â½X¬° 56¡B57¡B59¡A¤~¯à¦C¤J°Ñ¦Òª÷ÃB...

[µo°Ý] ²Å¦X©Ò»Ý¥N½X «e¨â½X¬° 56¡B57¡B59¡A¤~¯à¦C¤J°Ñ¦Òª÷ÃB...

1.³Æµù(EÄæ)¤Î¬ì¥Ø(FÄæ)Äæ¦ì¥u¦³¥X²{¼Æ¦r¥N½X«e¨â½X¬° 56¡B57¡B59 µ¥
    ¤~¯à²Å¦X±ø¥ó¦C¤J(GÄæ)°Ñ¦Òª÷ÃB(­ì¥»¥N½X¦³ 5 ¦ì¼Æ¨ú«e¨â½X)
2.³ÆµùÄ榳®É·|¥X²{¤å¦r+¥N½X(¨Ò¦p_E8_¸É59005)
3.½Ð°Ý GÄæ µª®×¤½¦¡¸Ó¦p¦ó½s¼g>>>



0202.rar (7.31 KB)

©T©w¤­½X, ¥B¤å¦r¦b«e­±,
°}¦C¤½¦¡:
=IF(OR(LEFT(RIGHT(E2:F2,5),2)={"56";"57";"59"}),D2,"")

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# ­ã´£³¡ªL

·PÁ«ü¾É   ^^

°ß¤@¨ü­­
­Y¬O¤å¦r¦b¼Æ¦r¥N½X«á¸Ó¤½¦¡µLªk¿ëÃÑ...
(¤å¦r¦b«e¥B¥N½X¬°5¦ì¼Æµª®×¥¿½T)

TOP

¦^´_ 3# hcm19522

·PÁ«ü¾É   ^^
¤GÄæ«e¨â½X ¥ô¤@¬°«ü©w¼Æ (8003)

¦b  https://blog.xuite.net/hcm19522/twblog/589596291 ¦³¸Ô²Ó°Ñ¦Ò

TOP

°²³]¬ì¥Ø¼Æ¦r©T©w¬°5¦ì¼Æ¡A¨ä«e¤è¤å¦r»¡©ú¤£¶W¹L9­Ó
G2 =IF(OR(LEFT(MAX(IFERROR(--MID(E2&F2,{1,2,3,4,5,6,7,8,9},5),"")),2)={56,57,59}&""),D2,"")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2021-2-4 10:54 ½s¿è

¦^´_ 4# cypd

¤å¦r¦b«e¦b«á¬Ò¥i, ¼Æ¦r¤£­­¤­½X
°}¦C¤½¦¡(¤TÁä¿é¤J)
=IF(COUNT(0/TEXT(MID("/"&E2:F2,FIND({56;57;59},E2:F2),1),";;;!1")),D2,"")
©Î
=IF(COUNT(0/MID(E2:F2,FIND({56;57;59},E2:F2),5)),D2,"")

TOP

¦^´_ 7# ­ã´£³¡ªL

¤å¦r¦b«e¦b«á¬Ò¥i, ¼Æ¦r¤£­­¤­½X
°w¹ï¬d§ä...IF(COUNT(0/MID(E2:F2,FIND({56;57;59},E2:F2),5)),D2,"")...¦¹¤½¦¡¬°¥N½X¤¤¦³²Å¦X 56 57 59 §Y±a¥Xª÷ÃB
   
    ¦¹¤½¦¡¹ï©Ò»Ý¼Æ¦r¥N½X«e¨â½X¬° 56¡B57¡B59 µ¥
    ¤~¯à²Å¦X±ø¥ó¦C¤J(GÄæ)°Ñ¦Òª÷ÃB...¸Ó·Ç«h¨t«ü¥N½X   «e¨â½X  ¬°­n¥ó³á!!


§Æ±æ¸Ó¤½¦¡¯à¦A­×¥¿¥H¨Ñ°Ñ¦Ò...

TOP

¦^´_ 6# ML089

·P®¦ªü   ^^

¸g¹ê´ú
¬ì¥Ø¼Æ¦r©T©w¬°5¦ì¼Æ(¥i½Õ¾ã¤½¦¡¤º¼Æ¾Ú)¡A
¨ä«e¤è¤å¦r»¡©ú¤£¶W¹L9­Ó...«á­±¤å¦r¤£©ë

TOP

¦^´_ 7# ­ã´£³¡ªL

·P®¦«ü¾É¦^´_   ^^

¸Ó¤½¦¡¬°¤å¦r¦b«e¦b«á¬Ò¥i, ¼Æ¦r¤£­­¤­½X¤§­­...§¹¬ü§e²{   :victory:
°}¦C¤½¦¡(¤TÁä¿é¤J)
=IF(COUNT(0/TEXT(MID("/"&E2:F2,FIND({56;57;59},E2:F2),1),";;;!1")),D2,"")

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD