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

±Æ§Ç

±Æ§Ç




Book1.rar (6.62 KB)

¦^´_ 11# hcm19522


    ´ú¸Õ¤F. ok

    ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-8-24 10:04 ½s¿è

¦^´_ 10# Qin

(¤@)H I³]©w-->TEXT(~,yyy/mm/dd;;)-->¤½¦¡µLªk¸ÑŪ MM/DD/YYYY
(¤G)J3=IF(H3="","",IF($J$1-H3<0,"©|¥¼开©l",IF($J$1-I3>0,"¤wºI¤î","ɬ´f¤¤")))-->¦]¸gTEXT¬O «D¼Æ¦r ­Y§ï¥Î´î ¥i¤Æ¸Ñ
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

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



Test Promo.rar (73.49 KB)

TOP

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

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

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

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

¦^´_ 2# hcm19522


TOP

¦^´_ 2# hcm19522


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

   Book2.rar (9.26 KB)

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD