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

7¥ô¨ú2~6¤£­«½Æªº²Õ¦X¦Cªí

7¥ô¨ú2~6¤£­«½Æªº²Õ¦X¦Cªí

7¥ô¨ú2~6¤£­«½Æªº²Õ¦X¦Cªí.png
2018-4-29 14:36


»Ý¨D¡J
¨Ì¾ÚÀx¦s®æB1¡JH1ªº7­Ó¸¹½X¶¶§Ç¡A¥H¥ô·N¨ú¨ä2~6ªº¤­ºØ±Æ¦C²Õ¦X¡F
¦p¦³­«½Æªº²Õ¦X®É¡A¨ú¨ä¤¤1²Õ§Y¥i!
¸Ô¦p½d¨ÒÀÉ
7¥ô¨ú2~6¤£­«½Æªº²Õ¦X¦Cªí.rar (3.68 KB)

¥H¤W  ·Ð½Ð¦U¦ì«e½ú½ç±Ð!ÁÂÁÂ!

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2018-5-3 23:35 ½s¿è

¦³¦bª¾ÃÑ+§ä¨ì7¨ú2²Õ¦Xªí¦Cªº¨ç¼Æ¤½¦¡
¤G¬P
J2=IF(ROW()>22,"",INDEX(B:H,COUNTA(A:A),SUM((ROW()-1>={1,7,12,16,19,21})*1)))
K2=IF(ROW()>22,"",INDEX(B:H,COUNTA(A:A),ROW()-LOOKUP(ROW()-1,{1,7,12,16,19,21},{0,5,9,12,14,15})))

7¨ú3~6¤Wºô§ä¤F¦n¤[¡A³£¬O²Î­p±Æ¦C²Õ¦XÁ`²Õ¼Æªº¼Æ¾ÇÃD©ÎCOMBIN¨ç¼Æ¡A§ä¤£¨ì²Õ¦Xªí¦Cªº¨ç¼Æ¤½¦¡^^"
·Ð½Ð¦U¦ì¤j¤j«ü¾É!ÁÂÁÂ!

TOP

¦^´_ 4# hcm19522

´ú¸ÕOK¤F!
ÁÂÁ±zªº¤£§[½ç±Ð!·P®¦^^

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD