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

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

¦^´_ 10# PJChen
¥X¿ùªº­ì¦]¦b©w¸q¦WºÙn·|¦b²Ä¤@­Ó¤é´Á¥X²{¿ù»~­È
n¬°­pºâ­è¦n¤é´ÁÂà´«®É¦P¬°¤j©ó0.1ªº¼Æ¶q
¦Ó¼ÐÃD¦C(¤å¦r)¸gINT³B²z·|Åܦ¨¿ù»~­È
§ârng©w¸q¤é´Á½d³ò¤£¥]¨í¼ÐÃD¦C§Y¥i¸Ñ¨M
KWH_R3.rar (136.43 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 11# Hsieh

ª©¤j,

1)  §Ú¤£À´³o­Ó¤½¦¡,¯à§_¸Ô¸Ñ? y=INDIRECT("H"&'KWH(New)'!x&":H"&ROW())..............½Ð°Ý¬õ¦âªº"x"¥Nªíªº·N¸q¬O¤°»ò?
2)  «e­±ªº°ÝÃD¸Ñ¨M¤F,¦ýµo²{ KWH_R3ªºÀÉ,BÄæÁÙ¥X²{¤@¨Ç¤§«e¥¼µo²{ªº¿ù»~,¨Ò:B301:B319À³¸Ó¥þ¬°1,¦ý«o¥u¦³B301¬O1(¥uÁ|¨ä¤¤¤@¨Ò)

3) ¥H KWH_R3¬°¨Ò,AÄæ­Y­n¥é·ÓBÄ檺§@ªk,®É¶¡²Å¦X0:00:00~23:55:00¥BHÄæ¦ì¤j©ó0.1,¬°¦³®Ä°Ï¶¡,¦ý¤£°Ï¤À¤é´Á,¨Ò¦p:²Å¦X0:00:00~23:55:00ªº±ø¥ó,±q2/2 6:05~6:55¬O²Ä¤@­Ó¦³®Ä°Ï¶¡,«h¼Ð¥Ü¬°1(A86:A96),¨ä¦P¤é²Ä2­Ó¦³®Ä°Ï¶¡¬°11:10~12:50«h¼Ð¥Ü¬°2(A147:A167),A301:A319¼Ð¥Ü¬°5¡K.¨Ì¦¹Ãþ±À,¨ä¤½¦¡À³¸Ó«ç»ò¤U?

TOP

¦^´_ 12# PJChen

x=ROW(INDEX('KWH(New)'!rng,1,1))
rng©Ò±o¨ìªº¬O¦P¤@¤é´Áªº½d³ò
INDEX('KWH(New)'!rng,1,1)
´N°Ñ·Ó¨ìrngªº²Ä¤@­ÓÀx¦s®æ(¦P¤é´Áªº²Ä¤@µ§Àx¦s®æ)
ROW(INDEX('KWH(New)'!rng,1,1))
¶Ç¦^¸Ó¦ì¸mªº¦C¸¹
y=INDIRECT("H"&'KWH(New)'!x&":H"&ROW())
´N¶Ç¦^¦P¤é´Á²Ä¤@¦ì¸m¨ì¤½¦¡©Ò¦b¦CªºHÄæ¦ì½d³ò
­n¸Ñ¨M¿ù»~­È¥u¯à¦b§PÂ_n­È®É¥[¤J§PÂ_
±Nnªº¤½¦¡§ï¬°
=SUMPRODUCT((INT(OFFSET('KWH(New)'!y,,-2))<>INT(IF(ISNUMBER(OFFSET('KWH(New)'!y,-1,-2)),OFFSET('KWH(New)'!y,-1,-2),OFFSET('KWH(New)'!y,,-2))))*(OFFSET('KWH(New)'!y,-1,)>0.1)*('KWH(New)'!y>0.1)*1)

KWH_R3.rar (137.42 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 13# Hsieh

·PÁª©¤j­@¤ßªº¦^ÂÐ,
³o¨Ç¤½¦¡¹ï§Ú¨Ó»¡«Ü»Ý­n®É¶¡¨Ó®ø¤Æ,½Ð®e§Ú¥ý¬ã¨s.....

TOP

¦^´_ 13# Hsieh

ª©¤j¦n,
­ì12¼Ó©Òµo°Ýªº°ÝÃD,¥»·Q­n¦Û¦æ¸Ñµª,©`¦ó¸£³U¹ê¦b¤£¶}¬,¨ì²{¦bÁÙ¬O¥¼°Ñ³z¤]¥¼¸Ñ¨M!!
§Ú¤w¸g³Q§O¤H¶Ê±o­nµÛ¤õ¤F,¥u¦n¦A¨Dª©¤jÀ°¦£....
3) ¥H KWH_R3¬°¨Ò,AÄæ­Y­n¥é·ÓBÄ檺§@ªk,®É¶¡²Å¦X0:00:00~23:55:00¥BHÄæ¦ì¤j©ó0.1,¬°¦³®Ä°Ï¶¡,¦ý¤£°Ï¤À¤é´Á,¨Ò¦p:²Å¦X0:00:00~23:55:00ªº±ø¥ó,±q2/2 6:05~6:55¬O²Ä¤@­Ó¦³®Ä°Ï¶¡,«h¼Ð¥Ü¬°1(A86:A96),¨ä¦P¤é²Ä2­Ó¦³®Ä°Ï¶¡¬°11:10~12:50«h¼Ð¥Ü¬°2(A147:A167),A301:A319¼Ð¥Ü¬°5¡K.¨Ì¦¹Ãþ±À,¨ä¤½¦¡À³¸Ó«ç»ò¤U?

KWH_R4.zip (155.5 KB)

TOP

¦^´_ 15# PJChen

­pºâBÄæ¤W¤UÀx¦s®æ¬Û²§ªº¼Æ¶q
A13=(B13>0)*SUMPRODUCT(($B$13:B13<>0)*($B$12:B12<>$B$13:B13))
    KWH_R3.rar (137.42 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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

¦^´_ 18# PJChen

¨C¤é¸ê®Æ½d³ò¤Ö¤F²Ä¤@­Ó¦ì¸m
©w¸q¦WºÙk´î1§Y¥i

   KWH_R4.rar (162.34 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 19# Hsieh

ÁÂÁª©¤j,

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

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD