ANGELA

9000¨ÃµL·N«ä,¥i¥Î65536¨ú¥N
¥[­ÓIF( )¥h§PÂ_¦pªGµ²ªG¬O65536®ÉÅã¥Ü¬°""

tsuan

¦^´_ 10# ANGELA


   ª©¥D±z¦n:
¨Ï¥Î³Ì§C»ù¤½¦¡®É¡A¦]³]©w0,9000¡A¦]¦¹·|²£¥Í¦p¥þ³¡µL¤H³ø»ù®É·|±a¥X9000ªº¼Æ¦r¡A©Î¦³¶W¥X9000®É¥çµLªk±a¥X¥¿½T¼Æ¦r¡A¤£ª¾¬O§_¦³¸Ñ?

tsuan

·P¿Eª©¥D
¥¿¬O§Ú©Ò»Ý­n¡A¦A¤]¤£¥Î·Ð´o¼t°Ó¼W´î¤F¡C
¦ý°}¦C¤½¦¡ÁÙ¯u»Ý­nÅÞ¿è°÷±j¤~§Ë±o¥X¨Ó¡C

ANGELA

=MIN(IF(N(OFFSET(G3,,(ROW(INDIRECT("$A1:$A"&COUNTA($E$1:$V$1)))-1)*3))=0,9000,N(OFFSET(G3,,(ROW(INDIRECT("$1:$"&COUNTA($E$1:$V$1)))-1)*3))))

tsuan

·PÁª©¥D¡A§Ö¼Ö¨Ï¥Î¤¤¡C
Áö¥i±¤"³Ì§C®É»ù" ¨S¦³¾A·í¤è¦¡¡A¦ý¤w¸g§ïµ½¤Ó¦h¤F

ANGELA

y3=IF(X3="","",INDIRECT("r1c"&5+(MATCH(X3,N(OFFSET(G3,,(ROW(INDIRECT("$1:$"&COUNTA(E$1:T$1)))-1)*3)),)-1)*3,))
z3=IF(X3="","",INDIRECT("rc"&5+(MATCH(X3,N(OFFSET(G3,,(ROW(INDIRECT("$1:$"&COUNTA(E$1:T$1)))-1)*3)),)-1)*3,))
aa3=IF(X3="","",INDIRECT("rc"&5+(MATCH(X3,N(OFFSET(G3,,(ROW(INDIRECT("$1:$"&COUNTA(E$1:T$1)))-1)*3)),)-1)*3+1,))

tsuan

¦^´_ 6# ANGELA


    ¦A½Ð°ÝANGELA :
¦A»{¯uºN·j«á¦³µyµy²z¸Ñ¨Ç¤F¡A¦ý°}¦C¤½¦¡§Ú¯uªºÁٻݦh¥[¬ã¨s¤~¦æ¡C¬O§_¥i¥H¦AÀ°§Ú§Ë¥X³Ì§C®É»ù¡B§t¦B²v¤Î±o¼Ð»ùªº°}¦C¤½¦¡©O?
Àµ¨DÀ°¦£¤F!

ANGELA

¨º¤@¬q¤£¤F¸Ñ,¥i¥H¥Î¤½¦¡½]®Ö,¬d¬Ý.¥t¥i¥Î·Æ¹«§â½s¿è¦Cªº¨ä¤¤¤@¬q¤½¦¡¤Ï¥Õ,
¦A«öf9§Y¥iª¾¹D¤½¦¡ªºÅܤÆ.

tsuan

¦^´_ 4# ANGELA


   ¤£¬O«Ü²z¸Ñ¡A¥i¥Hµy¥[¸ÑÄÀ¤@¤U¶Ü?

ANGELA

AE3=IF(X3="","",INDIRECT("r1c"&5+(MATCH(X3,N(OFFSET(G3,,(ROW(INDIRECT("$1:$"&COUNTA(E$1:T$1)))-1)*3)),)-1)*3,))
°}¦C¤½¦¡