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

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

¦^´_ 16# Hsieh

·PÁ¤j¤j,

¤Tµf¤G¦¸³Â·Ð±z!!³o¶¥¬q°õ¦æ¨S°ÝÃD¤F,§Ú±o¶i¦æ¤U­Ó¨BÆJ¤F,¶g¤T¦¸°µ¤£§¹,§Ú´N­nÂ_ÀY¤F.... ·PÁÂÀ°¤F¤j¦£¤F!!

TOP

¦^´_ 16# Hsieh

¤j¤j, ¤£¦n·N«ä...

¤§«eªºR3Àɦ³¿ù¦p¤U,¤w¨Ì±zªº«üÂI§@¤F­×§ï....¨ì²{¶¥¬q:±Nrng©w¸q¤é´Á½d³ò¤£¥]¨í¼ÐÃD¦C,·|¥X¿ù,½Ð¬Ý²{¦bªºR4ÀÉ(¤§«eªº¤£²z·|)
10Fªº°ÝÃD:  §Úªºªí®æ¨Ì§@·~µy§@¤F¨ÇÅÜ°Ê,¤£ª¾¬°¦óBÄ檺2/2ªº­È¬Y¨Ç·|¥X²{#VALUE!
11F®É¤j¤j«Øij±N: rng©w¸q¤é´Á½d³ò¤£¥]¨í¼ÐÃD¦C§Y¥i¸Ñ¨M

KWH_R4.zip (175.22 KB)

TOP

¦^´_ 19# Hsieh

ÁÂÁª©¤j,

¤u§@¤Ó»°,§zÔ¬§]´Ç,®ø¤Æ¤£¨}....
¥u¯à¨Æ«á¦h¸É±j.

TOP

¦^´_ 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

¦^´_ 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

¦^´_ 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

¦^´_ 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

¦^´_ 30# Hsieh

½Ð°Ý..

"R"&MATCH(M5,M:M,0) > R¬Oªí¥ÜR1 (1¬Ù²¤)& MATCH(M5,M:M,0)ªí¥ÜCxx (²Ä´X­Ócolumn?)

¦Ü©ó "C13:RC13" §ÚÁÙ¬O¸ÑŪ¤£¥X

¤£¹L¨Ì·Ó§A­×§ïªº¤½¦¡,¤w¥i°õ¦æ.

TOP

¦^´_ 32# Hsieh

ÁÂÁª©¤j²M·¡ªº¸Ñ»¡,§Ú¦A¦Û¦æ²z¸Ñ¤@¤U..

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD