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

¯Zªí¨î§@

¯Zªí¨î§@

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2011-11-28 20:39): ½Ð¤W¶ÇÀÉ®×»¡©ú

¥»©«³Ì«á¥Ñ v60i ©ó 2011-11-28 22:06 ½s¿è

¦]¬°¤H¼Æ«Ü¦h
¦Ó¥B¤â¥´ªº±`±`·|KEY¿ù
½Ð°Ý¥i¥H¥ÎEXCEL ¦Û°Ê¶]¥X
¤@¦~¥÷°µ¥|¥ð¤Gªº¯Zªí¶Ü
2000.zip (2.47 KB)

Ãþ¦üÂ檺
¦n¹³«Ü½ÆÂø =¤f=

½Ð°Ñ¦Ò 2000.zip (11.09 KB)

TOP

¦^´_ 2# ANGELA
¤j¤j¥i§_½Ð°Ý
    =IF(H2="","",IF(MOD(H2+3,6)+1>2,"¤é","¥ð"))

¤¤ªº+1>2 ¬O ¤°»ò·N«ä©O

TOP

¦^´_  ANGELA
¤j¤j¥i§_½Ð°Ý
    =IF(H2="","",IF(MOD(H2+3,6)+1>2,"¤é","¥ð"))

¤¤ªº+1>2 ¬O ¤°»ò·N«ä ...
v60i µoªí©ó 2012-1-12 06:40



    +1¨S¤°»ò·N¸q,¥u¬O²ßºD,¦]¬°MOD(row(1:6),6)·|±o¨ì{1;2;3;4;5;0},¤£·Q­n¥X²{0,¥[1·|±o¨ì{2;3;4;5;6;1}
     ¤£¥[1,§ï>1¤]¦æ. ¦pB4   =IF(B2="","",IF(MOD(B2-1,6)>1,"¤é","¥ð"))

TOP

¦^´_ 4# ANGELA


    ÁÂÁªO¤jªº±Ð¾Ç

TOP

½Ð°Ý =LOOKUP(99999,B2:AF2)+1    ¬O¤°»ò·N«ä?
ÁÂÁÂ

TOP

½Ð°Ý =LOOKUP(99999,B2:AF2)+1    ¬O¤°»ò·N«ä?
ÁÂÁÂ
aer µoªí©ó 2012-10-10 15:32


¥t¥~¡A¦A½Ð±Ð¤@¤U¨ä®æ¦¡¤@©w­n³]©w¬°¡A¦Û­q®æ¦¡ d¡A¤~¯à¥¿±`Åã¥Ü¼Æ­È¶Ü?  ÁÂÁÂ

TOP

ÁÂÁªO¤jªº±Ð¾Ç

TOP

ÁÂÁÂ
³Ìªñ¤]¦b¬ã¨s±Æ¯Zªº°ÝÃD!!

TOP

¨ä¹ê99999¬°¤é´Á§Ç¦C­È===>2173/10/13
¤½¦¡LOOKUP(99999,B2:AF2)+1,³o®É§A´N·|µo²{99999·|©MB2:AF2ªº¤é´Á¥h°µ¤ñ¸û,³Ì±µªñªº¬°31,¦¹®É¦A+1,´N¬O¤U1­Ó¤ëªº±Ò©l¤é´Á

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD