ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¨ú«e3¤p(¤¤¦¡±Æ¦W)ªº¦PÄæ²Ä1¦C¼Æ¦r¡C

¦^´_ 20# ML089
ML089ª©¥D:±z¦n!
ÁA¸Ñ^^
²Ä¤@¦Cªº01~49¼Æ¦r¤£·|­«ÂСC
·PÁ±zªº¸É¥R¡C
±zªº¤½¦¡§ÚÁÙ¦b®ø¤Æ¤¤~
§Æ±æ¯à¹F¨ì¦Û¤v­×§ï¬°«e3¤j(¥]¬A¤ñ¹ï71¦C®É¡A¤]¬O¨ú¦PÄæ¤ñ¸ûªº¼Æ¦r)ªº¥Øªº^^"

TOP

¦^´_ 21# papaya

»Ý¨D¡J
±NB¡JAX¦@49Äæ¤À¦¨5Äæ+5Äæ+5Äæ+5Äæ+5Äæ+5Äæ+5Äæ+5Äæ+5Äæ+4Äæ¦@10°Ï¬q
²Î­p¦U°Ï¬q¦b²Ä7,14,21,28,35,42,49,56,63,69¦Cªº³Ì¤p©M²Ä¤G¤p©M²Ä¤T¤p(¤¤¦¡±Æ¦W)ªº¦PÄæ²Ä¤@¦Cªº¼Æ¦r¡C
½Ð°Ý¡JAZ7¡JCC7ªº¨ç¼Æ¤½¦¡¡H
¸Ô¦p¡J°Ï¬q´ú¸ÕÀÉ¡C
ÁÂÁ±z¡I


³oÃDªº³Â·Ð¬O
X¦V¬°¶¡¶Z5¡A³Ì«á¤@®æ¶¡¶Z4
Y¦V¬°¶¡¶Z7¡A³Ì«á¤@®æ¶¡¶Z6
­Y¯à±N¸ê®Æ³W®æ±Æ¦C¡A¥ç¯à¨Ï¤½¦¡§ó²¼ä¡C
­pºâ¸ê®Æªº®Ö¤ßº¡Â²³æªº¡A¥i¥H­n¤½¦¡§ä¸ê®Æ©w¦ì¸ê®Æ¯Ó¶O¤Ó¦h°µ·~¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2019-4-22 11:53 ½s¿è

¦^´_ 22# ML089
ML089ª©¥D:±z¦n!
§Ú¤]ÁA¸Ñ°ÝÃD¥X¦b³Ì«á¤@°Ï¬qªºÄæ¦C»P¨ä¥L°Ï¬q¤£¦P¡A¦ýApp¤U¸ü¨ì¹q¸£«áÂàExcel´N¬O³o¼Ëªº©T©w®æ¦¡¡A¤]´¿·Q­n¥H¤â¤u´¡¤J¤@ªÅ¥Õ¦C¡A
¦Ó¥B´Á¼Æ§ó·s«á¡A¨C¦¸¶K¸ê®Æ®É¡A¸ê®ÆÁÙ­n¤À¬q­«·s¶K¤W¡A¤×¨ä¬O¤@§ó§ï´N­n°Ê49­ÓÀÉ®×*6ºØÃþ«¬*3ºØ±Æ§Ç=855­ÓÀɮסA
µM«á49­Ó¸¹½X¡A¥ô¦ó±Æ§Çªº³Ì«á°Ï¬qÁÙ¬O4­Ó¸¹½X¡AÁÙ¬OµLªk¥þ³¡°t¦X¤@¦¡¨ì©³ªº¤½¦¡~¦]¦¹¥u¦n¥H¤½¦¡¨Ó¾E´N®æ¦¡~
²¦³º¤½¦¡¥u­n¶K¤@¦¸§@½d¥»¡A´Á¼Æ§ó·s«á¡A¥u­n¿ï¾Ü¶K¤W¯Â­È´N¥i¥H¤F¡C
µ¹±z¦b¸ÑÃD®É¡A¼W²K³\¦hªº§xÂZ¡A¯u¬O©êºp^^"

¦A¦¸·PÁ±zªº­@¤ß«ü¾É^^
«á±Ô:
¦Ñ¹ê»¡:§Ú¥»¨Ó¬O·Q10­Ó°Ï¬q¤À§@10­Ó¤½¦¡¡A¤£»Ý­n«D±o¤@¦¡¨ì©³§¹¦¨~¦]¬°¤½¦¡¥u­n¶K¤@¦¸§@½d¥»´N¤£¥Î¦A§ó°Ê¤F¡C
¤]´¿·Q¥HVBA¨Ó§¹¦¨¡A¦ý·Q¨ì³o»ò¦h¦¡¼Ëªº»Ý¨D¡A¤ÀN¦¸µo°Ý¡A¯à¤£¯à±o¨ì³Ì²×µ²ªG¤]¬O¥¼ª¾¼Æ¡A¦]¬°±`±`ªá¤F¤@¤G­Ó¤ëªº®É¶¡¡A±o¨ì9¦¨ªº¶¥¬qµª®×¡A
¦ý³Ì²×¤@¦¨ªºµ²ªGµo°ÝÃD¡A«o­è¦n³£µL¤H²z¡A«e¥\ºÉ±ó¤S¦p¦ó?¥u¯à®{¹Ä½}¤F~©Ò¥H¥´®ø¥HVBA¨ú±o»Ý¨Dªº©ÀÀY^^"

TOP

¦^´_ 23# papaya

¤F¸Ñ¡AºÉ¶q°t¦X¸ê®Æ¨Ó·½®æ¦¡¬O¤ñ¸û¦n

¦³®É¤j®a®É¶¡¨Ã¨S¦³¨º»ò­è¦n¦³ªÅ¡A·|³y¦¨¶K¤åµL¤H°Ý¬z¡A¥i¥H¹L¤@°}¦A¶K¤@¦¸¡C

·íµM²¤Æ°ÝÃD©Î¤À³Î°ÝÃD¤]»Ý­n¡A¤@¯ë´N¯à¨M¸Ñªº°ÝÃD¤j®a®e©ö¦^µª¡A­Y­n·Q¤@¤U¡A±`±`·Q¤@¤U´N§Ñ°O³o­Ó°ÝÃD¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 24# ML089
ML089ª©¥D:±z¦n!
¤£¦n·N«ä¡A¶¶¹D½Ð±Ð¤@¤U:
10°Ï¬q¦U¤À¦¨10¬q¤½¦¡¡A¤½¦¡·|²¤Æ¨Ç¶Ü?
¦pªG¥i¥Hªº¸Ü¡A½Ð±z¼gAZ7:BB7©MCA69:CC69´N¦n¡A¨ä¥¦°Ï¬qªº¦ì§}©M««ª½¦C¼ÆÅܤƧڦۤv§ó§ï¡C
µ¥±z¦³ªÅ¦A»¡¡CÁÂÁ±z^^

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2019-4-22 18:30 ½s¿è

¦^´_ 24# ML089
¸É¥R~
¤W¤@¼ÓªºAZ7:BB7©MCA69:CC69ªº°ß¤@§Æ±æªº¬O2003ª©ªº¤@¯ë¼Æ­È«¬°}¦C¤½¦¡¡A
¤£¥Î¤@¦¡¨ì©³§¹¦¨¡A¤]¤£¥Î"°£¿ù"¡C

±ß¶º«á¡C§Ú¦A§@¤@­Ó½d¨Ò¡A
©Ò¥Hµ¥©ú¤Ñ¥H«á¡A±z¦³ªÅ¦A»¡´N¥i¥H¤F¡C
ÁÂÁ±z^^

TOP

¥»©«³Ì«á¥Ñ 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^^

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD