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

[µo°Ý] ½Ð°Ý¸Ó¦p¦ó¤~¯à­pºâ¸ÓÄæ³Ì«á¤­µ§¸ê®Æ

[µo°Ý] ½Ð°Ý¸Ó¦p¦ó¤~¯à­pºâ¸ÓÄæ³Ì«á¤­µ§¸ê®Æ

½Ð°Ý§Ú¦³¤@Äæ¸ê®Æ¨C¹j¤@¬q®É¶¡´N·|¼W¥[¼Æ­È¡A
¤£ª¾¹D¸Ó¥Î¦óºØ¨ç¼Æ¤~¥i°µ¨ì§Ú­nªº»Ý¨D
ÁٽЦU¦ìÀ°¦£¡AÁÂÁÂ

¦^´_ 13# jak

¤£«È®ð°Õ¡A§Ú¥»¨Ó¤]¨S¥Î¹L³o­Ó¨ç¼Æ¡A¤]¬O¦³§Aªº°ÝÃD¡A¤~Åý§Ú¥h¾Ç²ß¥¦ªº¡A³o´N¬O©Ò¿×ªº±Ð¾Ç¬Ûªø§a~

TOP

¦^´_ 10# mei27

¯uªº­n¾ÇªºÁ٫ܦh,·PÁÂmei27¤j¤j¸Ô²Óªº¸Ñ»¡

TOP

¦^´_ 11# jak

IF(X-COUNTA(1:1)<-5,-5,X-COUNTA(1:1)
§A¦pªG¦³¤F¸Ñ³o­Ó¤½¦¡ªº·N¸q¡A¨º´N¥i¥H¦Û¤v­pºâ¤F¡A
°²³]²{¦b¥u¦³7/1³o¤Ñªº¸ê®Æ¡A¨º¤½¦¡ªº³Ì«á¤@­Ó¼Æ­È´N¥²¶·µ¥©ó-1¡A
=AVERAGE(OFFSET(D2,0,-1,1,-1))
µM«á§A¦Û¤v¦bÀH«K¤@®æ¿é¤J=COUNTA(1:1), ­pºâ¥X¨Óªº­È¬O5¡A
¨º§A´N¯à«Ü²M·¡©ú¥Õªººâ¥XX-COUNTA(1:1)=-1ªºX¬O¦h¤Ö¤F§a¡A
¨Ì¦¹Ãþ±À¡A7/2ªº®É­Ô¡A³Ì«á¨º­Ó­È´N·|Åܦ¨-2¡A¦ÓCOUNTAªº­È¬O6
X-6=-2
¦Ó·í¶W¹L²Ä5¤Ñ¶}©l¡A¨º­Ó­È´N¤@©w¬O©T©w¬°-5¡A
©Ò¥H¤~­n¥ÎIF(X-COUNTA(1:1)<-5,-5

TOP

¥»©«³Ì«á¥Ñ jak ©ó 2013-7-27 19:59 ½s¿è

¦^´_ 10# mei27

§Æ±æ¯à¦A§ó¶i¤@¨B¤F¸Ñ¡A­Y¬OAÄæ¡BBÄæ¬Ò¬O¤£¦C¤J­pºâªºÄæ¦ì(¦p¹Ï)¡A"IF(3-COUNTA(1:1)<-5,-5,3-COUNTA(1:1)"­n¦p¦ó°µ­×§ï¡H
±æ¤j¤j½ç±Ð

¹Ï¤ù 3.png (13.08 KB)

¹Ï¤ù 3.png

TOP

¦^´_ 9# jak


=AVERAGE(OFFSET(K2,0,-1,1,IF(3-COUNTA(1:1)<-5,-5,3-COUNTA(1:1))))

¦]¬°¬O­nºâ©¹«e±À5¤Ñªº¸ê®Æ©Ò¥H­n¥Îoffset¡A¦pªG¬Oª½±µ©w¸qªº¸Ü¡A¬O³o¼Ëªº¡G
=AVERAGE(OFFSET(K2,0,-1,1,-5))  
»y·N¬°¡G­pºâ¥­§¡(K2¨º®æ¡A¦P¤@¦C¡A«á¤@Äæ¶}©l¡A§ì¨ú½d³ò¡G1¦C¡A§ì¨ú½d³ò¡G©¹¥ª5Äæ)
¥i¬O¦pªG¬O±q²Ä¤@¤Ñ¶}©l¿é¤J¸ê®Æ¡A¨º5¤é§¡¥ªÃä´N¨S¦³¤­Äæ¥i§ì¡A´NÅܦ¨¶Ã½X¤F¡A©Ò¥H­n§â-5§ï¦¨ÅܼÆ
¤]´N¬O¥Î"IF(3-COUNTA(1:1)<-5,-5,3-COUNTA(1:1)"¥h¨ú¥N-5
³o¼Ë¤@¨Ó¦pªG¥u¦³«e¤G¤Ñªº¸ê®Æ¡A¥L´N§ì¤G¤Ñªº¥­§¡¡A¤@ª½¨ì¶W¹L¤­¤Ñ¤§«á¡A¥L¤~·|¦Û°Ê§ì³Ì«á¤­¤Ñªº¥­§¡¡C

TOP

·PÁÂmei27¤j¤jªºÀ°¦£
¥i¥H½Ð±Ð¤j¤j  IF(3-COUNTA(1:1)<-5,-5,3-COUNTA(1:1))¬O¤°»ò·N«ä¶Ü¡H

TOP

¦^´_ 6# jak

²×©ó¸Ñ¥X¨Ó¤F¡A
5¤é§¡ªº¤½¦¡¡G=AVERAGE(OFFSET(K2,0,-1,1,IF(3-COUNTA(1:1)<-5,-5,3-COUNTA(1:1))))
¤ë§¡ªº¤½¦¡¡G=AVERAGE(OFFSET(A2,0,1,1,COUNTA(1:1)-3))
³o¼Ë±q²Ä¤@¤Ñ°_¨ì³Ì«á¤@¤Ñ¡AÀ³¸Ó³£¯àºâ±o¥X¨Ó

TOP

¦^´_ 6# jak

§Ú¥u·|ºâ³Ì«á¤­µ§ªº¸ê®Æ¡K
=AVERAGE(OFFSET(K2,0,-1,1,-5))

TOP

­Y¬O¾î¦¡ªí®æ¡A¥­§¡ªºÄæ¦ìºò±µ¦b¼Æ¾Ú«á­±¡A¨C¤é·|·s¼W¤@Äæ¼Æ¾Ú¡Aºâ¨C5¤Ñ¥­§¡©M30¤Ñ¥­§¡¡A³o¼Ë­n«ç»ò°µ¤ñ¸û¦n¡A³Â·Ð¦U¦ìÀ°¦£¡AÁÂÁÂ

¹Ï¤ù 5.gif (13.94 KB)

¹Ï¤ù 5.gif

TOP

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