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

[µo°Ý] ¦]Àx¦s®æ²£¥Í¼Æ¦r,¦Ó¦³¤F§Ç1,2,3,4......

[µo°Ý] ¦]Àx¦s®æ²£¥Í¼Æ¦r,¦Ó¦³¤F§Ç1,2,3,4......

Dear ALL
Àx¦s®æA7,A8,A9
¥u­n¦³¼Æ¦r
I7,I8,I9¦Û°Ê²£¥Í§Ç  1,2,4  ¡K¨Ì¦¹Ãþ±À
½Ð±Ð¦U¦ì¤j®v¯à§_¥Î IFªº¨ç¼Æ¸Ñ¨M
Kai 12.rar (196.35 KB)

Dear ALL
              ·PÁ¤j®a¼ö±¡ªº°Ñ»P,¥H¤Îgognª©¥Dªºµ{¦¡,
j7=if(a7="","",max(j$6:j6)+1)  ,¦¹µ{¦¡¸û¾A¦X³o¦¸ªº°ÝÃD,¦]³o¼Ëªºµ{¦¡¹J¨ìªÅ®æ¤£·|²£¥Í¥ô¦ó¼Æ¦r,¦³¼Æ¦r·|¦Û°Ê±Æ¦C,­ì¨Ó¥i¥H¦³³o»ò¦hªº¸Ñªk,·PÁ¦U¦ìªº°Ñ»P..ÁÂÁÂ

TOP

J7

=(A7<>"")*SUBTOTAL(3,A$7:A7)

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-5-16 16:14 ½s¿è
¤£§¹¬üªº¤½¦¡
j7=(A7"")+MAX($J$6:J6)

¦]¬°¨S¦³¨Ï¥Î if ©Ò¥H¤£¯à±Æ°£ªÅ¦C
¶È´£¨Ñ¥tÃþ«ä¦Ò,½Ö»¡¤@©w­n¥Î ...
asimov µoªí©ó 2010-5-16 01:55



    ±z¦n
±zªº¤½¦¡ªº½T¬O¥tºØ·Qªk
ª©¥D¥ÎªºIF¤½¦¡¥i¦b¦V¤U½Æ»s®É..©¹¤U½Æ»s¨ì©³«á
¥u¦³¦bA7«á¦³¿é¤J¼Æ¦r¤~·|¹ïÀ³¨ìJ7...JÄæ¤~·|²£¥Í¼Æ¦r±Æ§Ç.­YAÄæ¨S¿é¤JJÄ椽¦¡¤´¦b.¦ý¬O¤£·|¥X²{³Ì«á¤@­Ó§Ç¸¹¦b¤W­±


±zªº¤½¦¡¬O¨S¦³¥Î¨ìIF§PÂ_
¦ý¬O©¹¤U½Æ»s«á·|¥X²{¥þ³¡¬O³Ì«á¤@­Ó§Ç¸¹¦b¤W­± Kai 12-2.rar (193.26 KB)
´Nkai6929¼Ó¥D±z©Ò»Ý2ªÌ¤½¦¡¬Ò¥i¾A¥Î..
ÁÂÁÂ!

Kai-2.rar (10.39 KB)

TOP

¤£§¹¬üªº¤½¦¡
j7=(A7<>"")+MAX($J$6:J6)

¦]¬°¨S¦³¨Ï¥Î if ©Ò¥H¤£¯à±Æ°£ªÅ¦C
¶È´£¨Ñ¥tÃþ«ä¦Ò,½Ö»¡¤@©w­n¥Î if
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

ÁקKªÅ¦C²£¥Í°ÝÃD«Øij
j7=if(a7="","",max(j$6:j6)+1)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-5-14 19:16 ½s¿è

¦^´_ 1# kai6929


   J7=IF(A7=" "," ",1)
   J8=IF(A8=" "," ",J7+1)
   J9¦V¤U½Æ»s..

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD