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

(¤w¸Ñ¨M)½Ð°Ý­n¦p¦ó±N³øªí®æ¦¡¤º®eÂন¼Ï¯Ã¤ÀªR±o¸ê®Æ®æ¦¡

(¤w¸Ñ¨M)½Ð°Ý­n¦p¦ó±N³øªí®æ¦¡¤º®eÂন¼Ï¯Ã¤ÀªR±o¸ê®Æ®æ¦¡

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:15 ½s¿è

½Ð°Ý­n¦p¦ó±N³øªí®æ¦¡¤º®eÂন¼Ï¯Ã¤ÀªR±o¸ê®Æ®æ¦¡
Àɮפº¬O¥Î¤p§Ìªº¤è¦¡°µªº
¥i¬O³¡¤ÀÁÙ¨S¦³¦nªº¤è¦¡¸Ñ¨M
½Ð¦U¦ì¤j¤jÀ°¦£¬Ý¤@¤U¨Ã­×§ï¤ñ¸û¦nªº¤è¦¡

³øªí¸ê®ÆÂà¼Ï¯Ã¤ÀªR¸ê®Æ.rar (12.11 KB)

¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¥»©«³Ì«á¥Ñ gong ©ó 2010-7-7 08:46 ½s¿è

A3§ï¦¨IF(B3="","",INDEX($J$3:$J$18,COUNTIF($B$3:B3,B3)))¡Aµ²ªG¤]¬O¤@¼Ë
C3~D3¦pªG¤£·Q¥X²{0­ÈÀ³¸Ó¥i¥H±Ä¥ÎA3ORB3«e¬q³]©w¬°""ªº¤½¦¡¦p¡AIF((ROW()+12-3)/12>=COUNTA($J$3:$J$18)+1,"",SUMPRODUCT((­ì©l!$A$4:$A$51=µ²ªG!$A3)*(­ì©l!$B$4:$B$51=µ²ªG!C$2)*(­ì©l!$C$3:$N$3=µ²ªG!$B3)*­ì©l!$C$4:$N$51))
MOD¬Ý»¡©ú¬O¨â¦U¼Æªº¬Û°£«áªº­È¡A¥i¬O¹ê»Ú¾Þ§@¦n¹³¤£§¹¥þ¬O³o¼Ë¡A¦pªG²Ä2¦U¼Æ¬O12¡A±o¨ìªº­È·|¬O0-11¡C

§ï¦nªº¸ê®Æ¦pªþ¥ó¡A¤£ª¾¹D³o¼Ë¥i¥H¶Ü?

³øªí¸ê®ÆÂà¼Ï¯Ã¤ÀªR¸ê®Æ-new.rar (21.67 KB)

¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

°}¦C
¬ÛÃö¨ç¼ÆÁÙ¨SºN²M·¡
¥Ø«eµ¥¯Å¤Ó§C
¨S¿ìªk¤U¸üÀÉ®×Æ[¼¯
¬Ý¨ÓÁÙ¦³«Ü¦h§V¤OªÅ¶¡
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

§Ú·Q°Ý¤@¤U¦pªG¤£°µ¶i¶¥¿z¿ï±N¤£­«½Æªº¸ê®Æ§ä¥X¨Ó¦³§Oªº¤è¦¡¶]¥X³o­Óa3~c3ªºµ²ªG¶Ü? ...
freeffly µoªí©ó 2010-7-4 18:46



¥H¨ç¼Æ¤è¦¡¨ú±o¤£­«½Æ¸ê®Æ¥i°Ñ¦Ò³o½gºë±m¤å³¹
°Q½×¤£­«½Æ²M³æ
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

ÁÂÁÂasimov¤j¤j
¥u¦³c3ªº¤½¦¡§Ú·|
a3 ¸ò b3 ªº¤½¦¡µ¥§Ú¬ã¨s«á¦A¬Ý¬Ý¦³¨S¦³¤£·|ªº

§Ú·Q°Ý¤@¤U¦pªG¤£°µ¶i¶¥¿z¿ï±N¤£­«½Æªº¸ê®Æ§ä¥X¨Ó¦³§Oªº¤è¦¡¶]¥X³o­Óa3~c3ªºµ²ªG¶Ü?
ÁÙ¬O¥u¯à¥ý¥Î¶i¶¥¿z¿ï¥XÁ`¦@¦³­þ¨Ç«È¤á©O?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 1# freeffly


¤ë¥÷¤å¦r­n¬Û¦P
¸Õ¸Õ
"µ²ªG"¤u§@ªí
A3=IF(OR(B3="",COUNTIF($B$3:B3,B3)>COUNTA($J$3:$J$18)),"",INDEX($J$3:$J$18,COUNTIF($B$3:B3,B3)))
B3=IF((ROW()+12-3)/12>=COUNTA($J$3:$J$18)+1,"",MOD(ROW()-3,12)+1&"¤ë")
C3=SUMPRODUCT((­ì©l!$A$4:$A$51=µ²ªG!$A3)*(­ì©l!$B$4:$B$51=µ²ªG!C$2)*(­ì©l!$C$3:$N$3=µ²ªG!$B3)*­ì©l!$C$4:$N$51)
½Æ»sC3¤½¦¡¶K¤WD3¤ÎE3,¦A¥þ³¡¦V¤U½Æ»s
²Î­pµ²ªG¶W¹LA122375·|¥X²{¹s­È,¥u­n³]©w¤£Åã¥Ü¹s­È§Y¥i

³øªí¸ê®ÆÂà¼Ï¯Ã¤ÀªR¸ê®Æ.zip (24.73 KB)
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD