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

[µo°Ý] ½Ð°ÝT¤ÎUÄ椽¦¡¸Ó¦p¦ó¼g

[µo°Ý] ½Ð°ÝT¤ÎUÄ椽¦¡¸Ó¦p¦ó¼g

½Ð°ÝT¤ÎUÄ椽¦¡¸Ó¦p¦ó¼g?
½ÐÀ°¦£¸Ñµª¤@¤U¡AÁÂÁÂ

°ÝÃD.zip (396.65 KB)

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-5-3 14:35 ½s¿è

­nÁ¿¸Ñ¤@¤U¦p¦óÀò±oµª®×
¤£ª¾¹D23110¬O«ç»ò¨Óªº,¨S³W«h.
°Ñ·ÓSÄæ,²qªº,¸Õ¸Õ
t4=row(a1)
u4=N(U3)+I4
©¹¤Ucopy

TOP

TÄæ°Ñ·ÓDÄ椺¦³¼Æ¦rªº¨Ì§Ç±Æ¦C
¥H¦¹®×¬°¨Ò¡A®Öºâ³æ½s¸¹¤wµn°O¨ì²Ä6¥óTÄæ«h¥X²{¦Ü6
UÄæ=®Öºâ³æ½s¸¹TÄæ¹ï·Ó¦ÜIÄæ¹ê°µ¿nÂI+¤W¦C²Ö­p¿nÂI

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-5-3 16:55 ½s¿è

T4=IF(COUNTA($D$4:D100)<ROW(A1),"",ROW(A1))
U4=IF(T4<>"",N(U3)+VLOOKUP(T4,D:I,6,),"")
OR °}¦C¤½¦¡ °Êºµ½d³ò
t4{=IF(SUM((INDIRECT("D4:D"&COUNTA(A:A)+2)<>0)*1)<ROW(A1),"",ROW(A1))}

TOP

¦^´_ 4# ANGELA


½Ð°Ý«ö±zµ¹ªº¤½¦¡¿é¤J«á
U8¡BU9»P¥¿½T­È¤£²Å
½Ð¦bÀ°¦£Àˬd¤@¤U¬°¦ó¿ù»~
ÁÂÁÂÀ°¦£«ü¾É!

°ÝÃD2.zip (396.56 KB)

TOP

T4=IF(ROW(A1)>MAX(D:D),"",ROW(A1))
U4=IF(T4="","",SUMIF(D:D,T4,I:I)+IF(ISNUMBER(U3),U3,0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

=IF(T8<>"",N(U7)+VLOOKUP(T8,D:I,6,),"")
¤Ö¤F¤@­Ó³rÂI.¥[¤W§Y¥i.

TOP

ÁÂÁ¨â¦ìª©¥DªºÀ°¦£
²Å¦X¥¿½T¸Ñµª
«D±`·P®¦!

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD