±Æ§Ç

Qin

¤U¸ü (26.03 KB)

2017-7-27 21:46

Book1.rar (6.62 KB)

¤U¸ü¦¸¼Æ: 4

2017-7-27 21:50

hcm19522

http://blog.xuite.net/hcm19522/twblog/522660711

Qin

¦^´_ 2# hcm19522


    ÁÂÁÂ!

Qin

¦^´_ 2# hcm19522


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

   Book2.rar (9.26 KB)

¤U¸ü¦¸¼Æ: 3

2017-7-30 00:20

Qin

¦^´_ 2# hcm19522

¤U¸ü (49.6 KB)

2017-7-30 11:14

hcm19522

¦^´_ 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;;"),"")
¥[¬õ¦â

Qin

¦^´_ 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«ä?

hcm19522

¦^´_ 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

Qin

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

Qin

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

¤U¸ü (24.05 KB)

2017-8-23 15:40

Test Promo.rar (73.49 KB)

¤U¸ü¦¸¼Æ: 4

2017-8-23 15:47