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

¤é´Á´Á®Ä°ÝÃD

¤é´Á´Á®Ä°ÝÃD

Date_1.png
2017-7-19 23:26


Test_1.rar (6.28 KB)

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

TOP

¥»©«³Ì«á¥Ñ Qin ©ó 2017-7-20 23:40 ½s¿è

¦^´_ 2# hcm19522


   ¥i¥H¤F, ÁÂÁÂ!

   ©|¦³¤@°ÝÃD, ¦pªGEÄæ¨S¦³¤º®e®É, FÄæ¥i§_Åã¥Ü¬°ªÅ¥Õ?

TOP

¦^´_ 3# Qin


    «e­±¥[ if(e2="","",~~~)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522


    µL¨¥·P¿E..

TOP

¦^´_ 4# hcm19522


    hcm19522 «e½ú, ¦³¨Çµª®×¤£¥¿½T,
     §Ú§Æ±æ¥H"¤µ¤Ñ¤é´Á"¶}©l­pºâ,¦b6­Ó¤ë¦ZºI¤îªº¤é´Á, ¥þ³¡¥X¨Óªºµ²ªG¬O "6­Ó¤ë¥H¤W"

   
Date_2.png
2017-7-21 22:18

   
   

       Test_1.rar (7.45 KB)

TOP

¦^´_ 6# Qin

"YM" §ï¬° "M"

¡§ym¡¨ ·|¶Ç¦^¶W¥X§¹¾ã¦~¼Æªº³Ñ¾l¤ë¼Æ¡C
¡§m¡¨ ·|¶Ç¦^¨â­Ó¤é´Á¤§¶¡ªº§¹¾ã¤ë¼Æ¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089
«éµM¤j®© ¨ü±Ð¤F THANK
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

­Y¥Î¤@­Ó¤ë30¤Ñ¨Ó­pºâ¡A¥i¥H°Ñ¦Ò¤U¦¡

H2 =IF(E2="","",LOOKUP(E2,C$2-1+{-9999,1,2,3,4,5,6,7,8,15,31,61,91,121,151,181},A$2:A$17))
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089
  
    TQ

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD