ªð¦^¦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.jpg
2021-2-2 22:00


0202.rar (7.31 KB)

¦^´_ 15# Andy2483

·PÁ Andy2483 ´£¨Ñ¤£¦P¸Ñªk
Ãö©ó ¦r¤¸¦ì¸m_³Æµù = InStr("|65|75|95|", "|" & Right¡K
¨ä¤¤ "|65|75|95|" ¯«©_ªº¸Ñªk©O  ^^

TOP

ÁÂÁ½׾Â,ÁÂÁ¦U¦ì«e½ú
«á¾ÇÂǦ¹©«½m²ßVBA,¾Ç²ß¤è®×¦p¤U,½Ð¦U¦ì«e½ú«ü±Ð
°õ¦æ«e:
20231227_1.jpg
2023-12-27 07:51


°õ¦æµ²ªG:
20231227_2.jpg
2023-12-27 07:51


Option Explicit
Sub TEST()
Dim ¸ê®Æ°}¦C, i&, ¦r¤¸¦ì¸m_³Æµù%, ¦r¤¸¦ì¸m_¬ì¥Ø%
¸ê®Æ°}¦C = Range([F2], [D65536].End(xlUp))
For i = 1 To UBound(¸ê®Æ°}¦C)
   ¦r¤¸¦ì¸m_³Æµù = InStr("|65|75|95|", "|" & Right(Val(StrReverse(¸ê®Æ°}¦C(i, 2))), 2) & "|")
   ¦r¤¸¦ì¸m_¬ì¥Ø = InStr("|65|75|95|", "|" & Right(Val(StrReverse(¸ê®Æ°}¦C(i, 3))), 2) & "|")
   If ¦r¤¸¦ì¸m_³Æµù + ¦r¤¸¦ì¸m_¬ì¥Ø = 0 Then ¸ê®Æ°}¦C(i, 1) = ""
Next
[B2].Resize(UBound(¸ê®Æ°}¦C)) = ¸ê®Æ°}¦C
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 13# ML089

·P®¦Åo°Õªü   ^^

¸g¹ê´ú
³Æµù©Î¬ì¥Ø¼Æ¦r¦ì¼Æ¤£­­¬°5¦ì¼Æ(©Ò»Ý¥N½X·|¨ú «e¨â½X¬° 56¡B57¡B59)¡A
¨ä«e¡B«á¤è¤å¦r»¡©ú¦r¼Æ¤£©ë
¸Ó¤½¦¡¸g²¤Æ«á¬°¤å¦r¦b«e¦b«á¬Ò¥i, ¼Æ¦r¤W­­¬°20¦ì¼Æ¤§­­...¤Q¥þ¤Q¬ü

TOP

G2 =IF(OR(IFERROR(MID("X"&E2:F2,FIND({56;57;59},E2:F2),1),"")>"9"),D2,"")
°}¦C¿é¤J

¼Æ¦r¤£­­ªø¡A«e«á¥i¥H¦³¤å¦r¤£­­ªø
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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

·P®¦¤£§[«ü¾É

¸g±a¤J¤½¦¡...
sshot-1.jpg
2021-2-4 22:23


Åã¥Üµ²ªG...
¼Æ¦r¥N½X¨ü­­©ó 5 ­Ó¦r(¦h¤@­Ó¼Æ¦r©Î¤Ö¤@­Ó¼Æ¦rµLªk¥¿½TÅã¥Ü)
§Æ±æµ²ªG¬O...¤å¦r¦b«e¦b«á¬Ò¥i, ¼Æ¦r¤£­­¤­½X³á   ^^
(·Ç«h¨t«ü¥N½X   «e¨â½X¬° 56 57 59  ²Å¦X¬°­n¥ó³á)

TOP

¦^´_ 8# cypd

§Ñ¤F¶}ÀY¨â¦r,
=IF(COUNT(0/MID(E2:F2&"|",FIND({56;57;59},E2:F2),5)),D2,"")

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

¦^´_ 6# ML089

·P®¦ªü   ^^

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

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¥ó³á!!
0204.jpg
2021-2-4 14:59


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

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD