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

[µo°Ý] ¨D¤½¦¡,¤£ª¾¦p¦ó¤U¼ÐÃD?

¦^´_ 19# Hsieh

¤j¤j,

¶X²{¦bÀÉ®×¥i¥H¥´¶},§Ú§â¦Û©w¸qªº¸ê®Æ,¥þ³¡copy¥X¨Ó©ñ¦bL:SÄæ,¦ýÀˬd«áµo²{A:B/ N:PÄæ¥X²{«Ü¦hªº#N/A,¥i§_½Ð¤j¤j¼·¥X¤@¨Ç®É¶¡À°¦£Àˬd,¬O§_­n­×§ï³¡¥÷¤½¦¡?
¤£¦n·N«ä!!¦]¬°¨S¦³­×§ï¥¦,§Ú¦b¤½¥q¶}±Ò´X¥G¬O·í±¼ªº,§Ú´N¨Sªk§@¨ä¥L¨Æ¤F!!
KWH_R4.zip (280.81 KB)

TOP

¦^´_ 21# PJChen
©w¸q¦WºÙ¤¤ªº¤½¦¡¡A´«¦¨¼g¦bÀx¦s®æ¤º·|²£¥Í¤£¦P®ÄªG
§A¦b©w¸q¦WºÙ¤º©Ò¨£ªº¤½¦¡³£¬O¤@¯ë¤½¦¡
¦ý¦bÀx¦s®æ¤º¥i¯à´N¥²¶·¨Ï¥Î°}¦C¤½¦¡
¶}±Ò³t«×½wºC³o¬OµLªkÁקKªº
¦]¬°§Aªº»Ý¨D½ÆÂø¡A­n¨ú¥X¨C­Ó¤ÀÃþªº½d³ò´N¤w¸g¬O­Ó°ÊºA¡A¨C­ÓÀx¦s®æ§¡¶·­«ºâ¦ì¸m
¦A¥[¤W§Aªº¹q¸£®Ä¯à¤Ó®t¡A®Ú¥»¤£¾A¦X¨Ï¥Î2007¥H¤Wª©¥»(¦]¬°§Ú¹q¸£¶}±Ò¤£¶·¶W¹L1¤ÀÄÁ¡A§A«o­n1¤p®É)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 22# Hsieh

³oÃ䪺Àɮקڳ£¬O¤@¶}±Ò´N·í¾÷¡A§â¤½¦¡¦Û°Ê¹Bºâ§ï¦¨¤â°Ê¡A¤]¬O¤@­«ºâ´N·í¾÷
¦³ÂI¸Þ²§¡K¦]¬°³o¥xªº©Ê¯àÀ³¸Ó¨S¦³°ÝÃD(Intel Core i5 2450M, 8G memory)
¤£¹L´«¥x¹q¸£´N¨S°ÝÃD¤F(Intel Core i3-2120, 4G memory)

TOP

¦^´_ 23# Bodhidharma

§Ú¤]«Ü­W´o,©Ò¥H¤~·Q§ï¬°¤£­n¦Û©w¸q,¦ý¸Ì­±¤½¦¡¤Ó½ÆÂø,§Ú¦Û¤v¹ê¦b§ï¤£¥X¨Ó,­Y¦³¯à¤H¼ô±x¨ç¼Æ¤½¦¡ªº,¥i§_À°¦£­×§ï?·íµM§Úª¾¹D¦Û©w¸q¤½¦¡¥i¥H¬Ù²¤¨Ç¤½¦¡ªº®æ¦¡,¦ýÅv¿ÅÀɮ׶]¤£°Êªº±¡ªp,§Ú¬O¹çÄ@¦h´X¦æ¤½¦¡,¦ý¨D¶}ÀɦsÀɶ¶¹E....
ªþ¥óªº¤½¦¡¤w§ï¬°¤â°Ê,©Ò¥H¦Ü¤Ö¥i¥H¶}ÀÉ,¦Û©w¸q§Ú¤]ÁÙ«O¯d,¦ý§ï¬°"«D¦Û©w¸q¤½¦¡"§Ú´N¤£¦æ¤F.....
¨D...¼ô±x¨ç¼Æ¤½¦¡ªº¯à¤H,¥i¥HÀ°§U­×§ï,±NÀɮפ¤ªº"¦Û©w¸q¤½¦¡"¥þ³¡§ï±¼??³o¥u¬O¤@­Ó½d¨ÒÀÉ,¸ê®Æ·|¤@ª½¼W¥[,³Ì¦n¤£­n¨Ï¥Î°}¦C¤½¦¡.....

KWH_R4_¦Û©w¸q¦WºÙ.zip (165.44 KB)

TOP

¦^´_ 24# PJChen

À³¸Ó¬O°ÊºA½d³ò³y¦¨ªº­pºâ­«½Æ
¥[¨âÄ滲§UÄæ¸Õ¸Õ¬Ý
KWH_R4.rar (197.79 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 25# Hsieh

¤j¤j,
§Ú¬Ý¨ì±z¤w¸g±N¦Û©w¸q¦WºÙ§ï¦¨»²§U¤½¦¡,§Ú¤Ó¶}¤ß¤F,¯u¦hÁ±z!!

TOP

¦^´_ 25# Hsieh

¤j¤j,

½Ð±Ð:2/4¤§«áªº¤é´Á,HÄæ­È¤j©ó0.1,BÄæ­n±q1¶}©l¼Æ,¦ý¤£ª¾¬°¦ó±q«o¥X²{2?    KWH_R4_Hsieh.zip (202.83 KB)

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-4-14 10:12 ½s¿è

¦^´_ 27# PJChen
­pºâ¨â¤é¥æ´«®É³£²Å¦X³W«hªº¼Æ¶q½d³ò°ÝÃD
KWH_R4_Hsieh.rar (190.31 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 28# Hsieh

¤j¤j,

½Ð°ÝB2¤½¦¡¤¤,¬õ¦â¤ÎÂŦ⪺¦r,§Ú¬Ý¤£À´¥¦¦b¤½¦¡¤¤¥Nªí¤°»ò?½ÐÀ°¦£¸Ñ»¡?ÁÂÁÂ!!
B2=(D2<>0)*(SUMPRODUCT(ISNUMBER(1/((INDIRECT("R"&MATCH(M2,M:M,0)&"C13:RC13",0)=M2)*((INDIRECT("R"&MATCH(M2,M:M,0)&"C4:RC4",0)<>0)*(INDIRECT("R"&MATCH(M2,M:M,0)-1&"C4:R[-1]C4",0)=0))))*1)+P2)

TOP

¦^´_ 29# PJChen

INDIRECT¨ç¼Æ²Ä¤@­Ó°Ñ¼Æ¬OÀx¦s®æ¦ì§}¦r¦ê¡A²Ä2­Ó°Ñ¼Æ¬O¦r¦êªº§Î¦¡
²Ä2­Ó°Ñ¼Æ¬°1©Î¬Ù²¤«h¬O¥HA1§Î¦¡§PŪ²Ä¤@­Ó°Ñ¼Æ
²Ä2­Ó°Ñ¼Æ¬°0«h¥HR1C1§Î¦¡§PŪ²Ä¤@­Ó°Ñ¼Æ
R«á­±ªº¼Æ¦rªí¥Ü²Ä´X¦C¡AC«á­±¼Æ¦rªí¥Ü²Ä´XÄæ
¼Æ¦r¤w[](¤¤¬A¸¹)¥]³ò¡A«h¬O¥H¤½¦¡©Ò¦b¦ì¸m¬°­ìÂI¡A¦ì²¾ªº¶q
RCªí¥Ü¤½¦¡©Ò¦b¦ì¸m
R1C1¬°A1Àx¦s®æ
R[1]C[1]¬°¤½¦¡©Ò¦b¦ì¸m¦V¤U1¦C¡A¦V¥k1Ä檺¦ì¸m
R[-1]C[-1]¬°¤½¦¡©Ò¦b¦ì¸m¦V¤W1¦C¡A¦V¥ª1Ä檺¦ì¸m
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD