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

[µo°Ý] ½Ð±Ð¦p¦ó§â¾î¦¡ªí®æ²Å¦X±ø¥ó¸ê®Æ§ï¦¨ª½¦¡¥t¦C¦b¤@­Ó¤u§@ªí¤º

¦^´_ 19# myshowin

M2°}¦C¤½¦¡
=IF(ROW(A2)>(COUNTIF($B$2:$K$6,7)+COUNTIF($B$2:$K$6,8)),"",INDIRECT("A"&MOD(SMALL(IF(($B$2:$K$6>6)*($B$2:$K$6<9),--(COLUMN($B$2:$K$6)*100&ROW($B$2:$K$6)),""),ROW(A2)),100)))
N2°}¦C¤½¦¡
=IF(M2="","",INDIRECT("R1C"&SMALL(IF((INDEX($B$1:$K$6,MATCH(M2,$A$1:$A$6),)>6)*(INDEX($B$1:$K$6,MATCH(M2,$A$1:$A$6),)<9),COLUMN(INDEX($B$1:$K$6,MATCH(M2,$A$1:$A$6),0)),""),COUNTIF($M$1:M2,M2)),0))
O2°}¦C¤½¦¡
=IF(N2="","",INDEX($A$1:$K$6,MATCH(M2,$A$1:$A$6,0),MATCH(N2,$A$1:$K$1,0)))
XXX.png
2012-2-7 23:43
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 20# PJChen

§AÀ³¸Ó¬O¨Ï¥ÎÁä½L¤W±Æªº¼Æ¦r¡A¨Ï¥Î¦r¤¸½X¿é¤J¥²¶·«ö¦íALT+¼Æ¦rÁä
prado3s.jpg
2012-2-7 23:50
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 22# Hsieh

ÁÂÁ±z§ä¨ì¤F°ÝÃDªº©Ò¦b,¦b¼Æ¦rÁä¿é¤JAlt+160½T¹ê¥i¥H²£¥Í¤@­ÓªÅ¥Õ¦r¤¸,¦ýµLªk±N¥¦copy¶K¤W¨Ã¨ú¥N¬°¨ä¥¦¦r¤¸,µL½×§Ú¬Oª½±µcopyÀx¦s®æ,©Î±NªÅ¥Õ¦r¤¸¤Ï¶Â¿ï¨ú³£µLªkcopy!

TOP

¦^´_ 23# PJChen


    ª½±µ¦b´M§ä¥Ø¼Ð¤º¨Ï¥ÎALT+160
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 21# Hsieh

§Ú¤Ó²Â¡A¬Q¤Ñ¦Û¤w¸ÕµÛ­×§ï¤F´X­Ó¤p®É¡AÁ`¬O·|¦³¤Ö¡A
­ì¨Ó°ÝÃD¥X¦b¤U­±ÂŦrªº¦a¤è
«D±`·PÁ±zªº¸Ñµª¡A§ÚÀò©ö¨}¦h

¥H¤U¬O¶W¯Åª©¥DHsieh ±Ð¾Ç­ì¤å¡G
M2°}¦C¤½¦¡
=IF(ROW(A2)>(COUNTIF($B$2:$K$6,7)+COUNTIF($B$2:$K$6,8)),"",INDIRECT("A"&MOD(SMALL(IF(($B$2:$K$6>6)*($B$2:$K$6<9),--(COLUMN($B$2:$K$6)*100&ROW($B$2:$K$6)),""),ROW(A2)),100)))
N2°}¦C¤½¦¡
=IF(M2="","",INDIRECT("R1C"&SMALL(IF((INDEX($B$1:$K$6,MATCH(M2,$A$1:$A$6),)>6)*(INDEX($B$1:$K$6,MATCH(M2,$A$1:$A$6),)<9),COLUMN(INDEX($B$1:$K$6,MATCH(M2,$A$1:$A$6),0)),""),COUNTIF($M$1:M2,M2)),0))
O2°}¦C¤½¦¡
=IF(N2="","",INDEX($A$1:$K$6,MATCH(M2,$A$1:$A$6,0),MATCH(N2,$A$1:$K$1,0)))

TOP

¦^´_ 24# Hsieh
14FªB¤Í¬Q¤Ñ¦³´£¹L,§Ú¤]¸Õ¤F,µ²ªG¬O¨S¦³§@¥Î.

TOP

¦^´_ 26# PJChen
play.gif
2012-2-9 17:35
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 27# Hsieh

ÁÂÁª©¥D­@¤ßªº±Ð¾É,¦¨¥\¤F!

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD