- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¥»©«³Ì«á¥Ñ papaya ©ó 2019-4-22 21:27 ½s¿è
¦^´_ 24# ML089
ML089ª©¥D:±z¦n!
AZ7
=SMALL(IF(SMALL(IF(MATCH(OFFSET($B$6,LOOKUP(1,0/(B$7:B$7>0),ROW($1:1)),,,5),OFFSET($B$6,LOOKUP(1,0/(B$7:B$7>0),ROW($1:1)),,,5),)={1,2,3,4,5},OFFSET($B$6,LOOKUP(1,0/(B$7:B$7>0),ROW($1:1)),,,5)),COLUMN(A1))=OFFSET($B$6,LOOKUP(1,0/(B$7:B$7>0),ROW($1:1)),,,5),$B$1:$F$1),MOD(ROW(A1),7))
¥k©Ô¨ìBB7¤U©Ô¦ÜBB12
BC7
=SMALL(IF(SMALL(IF(MATCH(OFFSET($G$6,LOOKUP(1,0/(G$7:G$7>0),ROW($1:1)),,,5),OFFSET($G$6,LOOKUP(1,0/(G$7:G$7>0),ROW($1:1)),,,5),)={1,2,3,4,5},OFFSET($G$6,LOOKUP(1,0/(G$7:G$7>0),ROW($1:1)),,,5)),COLUMN(A1))=OFFSET($G$6,LOOKUP(1,0/(G$7:G$7>0),ROW($1:1)),,,5),$G$1:$K$1),MOD(ROW(A1),7))
¥k©Ô¨ìBE7¤U©Ô¦ÜBE12
¨ä¾lÃþ±À
CA7
=SMALL(IF(SMALL(IF(MATCH(OFFSET($AU$6,LOOKUP(1,0/(AU$7:AU$7>0),ROW($1:1)),,,4),OFFSET($AU$6,LOOKUP(1,0/(AU$7:AU$7>0),ROW($1:1)),,,4),)={1,2,3,4},OFFSET($AU$6,LOOKUP(1,0/(AU$7:AU$7>0),ROW($1:1)),,,4)),COLUMN(A1))=OFFSET($AU$6,LOOKUP(1,0/(AU$7:AU$7>0),ROW($1:1)),,,4),$AU$1:$AX$1),MOD(ROW(A1),7))
¥k©Ô¨ìCC7¤U©Ô¦ÜCE12
¨ä¾lÃþ±À
AZ69
=SMALL(IF(SMALL(IF(MATCH(OFFSET($B$68,LOOKUP(1,0/(B$69:B$69>0),ROW($1:1)),,,5),OFFSET($B$68,LOOKUP(1,0/(B$69:B$69>0),ROW($1:1)),,,5),)={1,2,3,4,5},OFFSET($B$68,LOOKUP(1,0/(B$69:B$69>0),ROW($1:1)),,,5)),COLUMN(A1))=OFFSET($B$68,LOOKUP(1,0/(B$69:B$69>0),ROW($1:1)),,,5),$B$1:$F$1),MOD(ROW(A1),6))
¥k©Ô¨ìBB69¤U©Ô¦ÜBB73
CA69
=SMALL(IF(SMALL(IF(MATCH(OFFSET($AU$68,LOOKUP(1,0/(AU$69:AU$69>0),ROW($1:1)),,,4),OFFSET($AU$68,LOOKUP(1,0/(AU$69:AU$69>0),ROW($1:1)),,,4),)={1,2,3,4},OFFSET($AU$68,LOOKUP(1,0/(AU$69:AU$69>0),ROW($1:1)),,,4)),COLUMN(A1))=OFFSET($AU$68,LOOKUP(1,0/(AU$69:AU$69>0),ROW($1:1)),,,4),$AU$1:$AX$1),MOD(ROW(A1),6))
¥k©Ô¨ìCC69¤U©Ô¦ÜCC73
½d¨ÒÀÉ:
«e3¤pªº¤¤¦¡±Æ¦W(¨S¦³¤ñ¹ï71¦C).rar (637.06 KB)
¦pªG¦A¥[¤W¤ñ¹ï71¦C(¦P¦W¦¸¨Ã±ÆªÌ¡A¤]¬O¨ú¦PÄæ¸û¤pªº¼Æ¦r¡A
½Ð±Ð±z:¤½¦¡n¦p¦ó½s¼g?
PS:§Æ±æ¬O2003ª©ªº¤@¯ë¼ÆÈ«¬ªº°}¦C¤½¦¡¡A¤£¥Î¤@¦¡¨ì©³§¹¦¨¡A¤]¤£¥Î"°£¿ù"¡C
ÁÂÁ±z^^ |
|