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

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

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



»Ý¨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

§A¥i¥H¥h°Ý°Ý01³o¦ì¤¯¥S¡A¥L¦³­Óvba´N¬O¸Ñ³oºØ°ÝÃDªº
¬Û«H§A·|¦³¦¬Àòªº
https://www.mobile01.com/topicdetail.php?f=511&t=5025613&p=1#62860459

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522

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

TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD