- ©«¤l
- 315
- ¥DÃD
- 51
- ºëµØ
- 0
- ¿n¤À
- 367
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-29
- ³Ì«áµn¿ý
- 2021-10-12
|
¦^´_ 27# ML089
ML089ª©¤j¡J±z¦n!
pºâSMALL¨ú¼Æ¦ì¸m==>¤wÁA¸Ñ~ÁÂÁ±z!
¦ý~
¨ú¤j $B$71:$AX$71%%
¨ú¤p 1/$B$71:$AX$71
ÁÙ¬O¤£¤ÓÁA¸Ñ(²Ä1¦¸±µÄ²¨ì%%)^^"
¥H¶Q¸Ñ¤½¦¡¬°¨Ò¡J
«e3¤j
=TEXT(SMALL(IF(LARGE($B7:$AX7+$B$71:$AX$71%%,1+COUNTIF($B7:$AX7,">="&INDEX(7:7,MATCH(--AY7,$1:$1,))))=$B7:$AX7+$B$71:$AX$71%%,$B$1:$AX$1,99),{1;2;3;4;5;6}),"[<>99];;")
«e3¤p
=TEXT(SMALL(IF(SMALL($B7:$AX7+$B$71:$AX$71%%,1+COUNTIF($B7:$AX7,"<="&INDEX(7:7,MATCH(--AY7,$1:$1,))) )=$B7:$AX7+$B$71:$AX$71%%,$B$1:$AX$1,99),{1;2;3;4;5;6}),"[<>99];;")
¬°¦ó«e3¤j©M«e3¤p³£¬O$B$71:$AX$71%%?
¤S¥Hh¤jªº¤½¦¡¬°¨Ò¡J
=SMALL(IF(MIN((SMALL((MATCH(OFFSET($B$1,LOOKUP(9^9,$AX65:$AX69,ROW(64:68)),,,49),OFFSET($B$1,LOOKUP(9^9,$AX65:$AX69,ROW(64:68)),,,49),)=COLUMN($B:$AX)-1)*OFFSET($B$1,LOOKUP(9^9,$AX65:$AX69,ROW(64:68)),,,49),COLUMN(A64))=OFFSET($B$1,LOOKUP(9^9,$AX65:$AX69,ROW(64:68)),,,49))*(OFFSET($B$1,LOOKUP(9^9,$AX65:$AX69,ROW(64:68)),,,49)/1%%+$B$71:$AX$71))=OFFSET($B$1,LOOKUP(9^9,$AX65:$AX69,ROW(64:68)),,,49)/1%%+$B$71:$AX$71,$B$1:$AX$1),MOD(ROW(A64),7))
¨ä%%ªº¦ì¸m¤Sn¦p¦óקאּ"¨ú¤p"?
¥H¤W ·q½Ð½ç±Ð!ÁÂÁ±z^^ |
|