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

±Æ§Ç

±Æ§Ç




Book1.rar (6.62 KB)

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

TOP

¦^´_ 2# hcm19522


    ÁÂÁÂ!

TOP

¦^´_ 2# hcm19522


  ¼W¥[¦h¤@Äæ¤é´Á, ¦ý¤£ª¾¸Ó¤U¤°»ò¤½¦¡?       

   Book2.rar (9.26 KB)

TOP

¦^´_ 2# hcm19522


TOP

¦^´_ 4# Qin

­ì¤½¦¡¦A¥k©Ô¤@®æ «á¤½¦¡§ï=IFERROR(TEXT(INDEX(D:D,RIGHT(SMALL(IF($B$3:$B$30<>"",$B$3:$B$30*10^6+ROW(D$3:D$30)),ROW(C1)),5)),"YYY/M/D;;"),"")
¥[¬õ¦â
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 6# hcm19522


    ÁÂÁÂ! °ÝÃD¤w¸Ñ¨M.

'=IFERROR(INDEX(B:B,RIGHT(SMALL(IF($B$3:$B$30<>"",$B$3:$B$30*10^6+ROW(B$3:B$30)),ROW(A1)),5)),"")

     
     ¤½¦¡¨½ªº "5" ¬O¤°»ò·N«ä?

TOP

¦^´_ 7# Qin

$B$3:$B$30*10^6+ROW(B$3:B$30)-->¦X¥G±ø¥óªÌ ,§Ç¸¹ÂX¤j *10^6+¦C¸¹ ,¦]¦³¤p¼ÆÂI¤@¦ì ,±Æ§Ç«á¨ú«á­±5¦ì(¦C¸¹¦ì¸m) ,¸gINDEX«á¬°©Ò»Ýµª®× ;10^6 OR 10^3¨ú«á­±2¦ì ,¥ç¥i ,¬Ý±Æ§Ç¸ê®Æ¶q
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 8# hcm19522
   
   
    ÁÂÁÂ...
   
    §Ú»Ý­n®É¶¡®ø¤Æ©M§l¦¬....

TOP

¦^´_ 8# hcm19522
   
¤é´Áª¬ºAÅ㤣¥¿½T, ¤£À´°ÝÃD¥X¦b¨º¨½?



Test Promo.rar (73.49 KB)

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD