Hsieh

¦^´_ 1# myshowin

M2°}¦C¤½¦¡=IF(ROW(A1)>COUNTIF($B$2:$K$6,">6"),"",INDIRECT("A"&MOD(SMALL(IF($B$2:$K$6>6,--(COLUMN($B$2:$K$6)*100&ROW($B$2:$K$6)),""),ROW(A1)),100)))

N2°}¦C¤½¦¡=IF(M2="","",INDIRECT("R1C"&SMALL(IF(INDEX($B$1:$K$6,MATCH(M2,$A$1:$A$6),)>6,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)))

Hsieh

¦^´_ 5# PJChen

°ÝÃD¥X¦b¥X¶Ô¤u§@ªí¤¤ªº¸ê®Æ³£¬O¤å¦r«¬ºA

    ¸ê®ÆÂà´«.rar (10.13 KB)

¤U¸ü¦¸¼Æ: 8

2012-2-6 19:01

Hsieh

¦^´_ 15# myshowin
§A¨ì²{¦b¤]ÁÙ¨S»¡²M·¡
9~15¦³7­Ó­È¡A½Öª¾¹D§A­n¨º¨Ç­È¥H7¨ú¥N¡A¨º¨Ç¥H8¨ú¥N

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

Hsieh

¦^´_ 23# PJChen


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

Hsieh

¦^´_ 26# PJChen

¤U¸ü (225.86 KB)

2012-2-9 17:35