Hsieh

¦^´_ 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)))

¤U¸ü (24.66 KB)

2012-2-7 23:43

Hsieh

¦^´_ 20# PJChen

§AÀ³¸Ó¬O¨Ï¥ÎÁä½L¤W±Æªº¼Æ¦r¡A¨Ï¥Î¦r¤¸½X¿é¤J¥²¶·«ö¦íALT+¼Æ¦rÁä

¤U¸ü (19.46 KB)

2012-2-7 23:50

PJChen

¦^´_ 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!

Hsieh

¦^´_ 23# PJChen


    ª½±µ¦b´M§ä¥Ø¼Ð¤º¨Ï¥ÎALT+160

myshowin

¦^´_ 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)))

PJChen

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

Hsieh

¦^´_ 26# PJChen

¤U¸ü (225.86 KB)

2012-2-9 17:35

PJChen

¦^´_ 27# Hsieh

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