- ©«¤l
- 142
- ¥DÃD
- 18
- ºëµØ
- 0
- ¿n¤À
- 160
- ÂI¦W
- 141
- §@·~¨t²Î
- win10 64¦ì¤¸
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- »OÆW °ª¶¯¥«
- µù¥U®É¶¡
- 2015-7-18
- ³Ì«áµn¿ý
- 2025-5-25
        
|
¥»©«³Ì«á¥Ñ lcctno ©ó 2015-8-28 23:15 ½s¿è
¦^´_ 36# azrael19
·PÁ±z ¥Ø«e¥u´ú¸Õ2Ó¤£¦P±Ú¸sªºdata §Ú«Ü°ª¿³ µ²ªG"§¹¥þ¥¿½T" ±zªº¨ç¼Æ¯uªº¤Ó±j¤F
Y¤è«Kªº¸Ü ¥i§_³Â·Ð¨Ï¥Î³Ì¥Õ¸Üªº¤è¦¡ §i¶D§C¯àªº§Ú ±z¦b"µ²ªG"¤À¶¤º ¨º3Ó¨ç¼Æªº·N«ä
°Ï¶¡=COUNTA(A:A)-1 ȬO¥¿½T ¦ý¬°¦ó¬O-1 ¦Ó¤£¬O-2( ¦]¬°§Ú¬Ý¨ì¦³2Ó¬O«D¼Æ¦r¦C) ?
¸ê®Æ¦C_³Ì°ª»ù '=OFFSET(INDIRECT(ADDRESS(IF(Data!$I$6="",2,Data!$I$6),3,,,"Data")),,,IF(Data!$J$6="",COUNTA(INDIRECT("Data!$A:$A"))-1,Data!$J$6-IF(Data!$I$6="",2,Data!$I$6)+1),) ³oÓ§Ú§¹¥þ¤£ª¾¹D¬O¤°»ò
¸ê®Æ¦C_³Ì§C»ù '=OFFSET(¸ê®Æ¦C_³Ì°ª»ù,,1,,) ³oÓ§Ú¤]§¹¥þ¤£ª¾¹D¬O¤°»ò
ÁÂÁ±z¤F |
|