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

±Æ§Ç

±Æ§Ç

Sort.png
2017-7-27 21:46



Book1.rar (6.62 KB)

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522


    ÁÂÁÂ!

TOP

¦^´_ 2# hcm19522


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

   Book2.rar (9.26 KB)

TOP

¦^´_ 2# hcm19522


Date_3.png
2017-7-30 11:14

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;;"),"")
¥[¬õ¦â
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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

TOP

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

Test Promo.png
2017-8-23 15:40


Test Promo.rar (73.49 KB)

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD