- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
a2=IF(ROW(¥X¶Ô!A1)>COUNTIF(¥X¶Ô!$B$2:$K$6,">6"),"",INDIRECT("¥X¶Ô!A"&MOD(SMALL(IF(¥X¶Ô!$B$2:$K$6>6,--(COLUMN(¥X¶Ô!$B$2:$K$6)*100&ROW(¥X¶Ô!$B$2:$K$6)),""),ROW(¥X¶Ô!A1)),100)))
b2=INDIRECT("¥X¶Ô!r1c"&SMALL(IF(INDEX(¥X¶Ô!$B$1:$K$6,MATCH(A2,¥X¶Ô!$A$1:$A$6,),)>6,COLUMN(INDEX(¥X¶Ô!$B$1:$K$6,MATCH(A2,¥X¶Ô!$A$1:$A$6,),0)),""),COUNTIF(A$2:$A2,A2)),0)
c2=IF(B2="","",INDEX(¥X¶Ô!$B$2:$K$6,MATCH(A2,¥X¶Ô!$A$2:$A$6,0),MATCH(B2,¥X¶Ô!$B$1:$K$1,0))) |
|