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

[µo°Ý] ¦p¦ó¦Û°Ê§ì¨ú«ü©w¤Ñ¼Æ­pºâ?

[µo°Ý] ¦p¦ó¦Û°Ê§ì¨ú«ü©w¤Ñ¼Æ­pºâ?

¦pªþÀÉ¡AÁÂÁ¦U¦ì¤j¤jÅo! help1.rar (7.8 KB)

B2¿é¤J
=IF(ROW()<$B$1+1,"",AVERAGE(OFFSET(A2,,,-$B$1)))
©¹¤U©Ô

TOP

=IF(ROW()>B$1,AVERAGE(INDIRECT("A"&ROW()-2&":A"&ROW())),"")

TOP

«¢«¢«¢¡A¯u¬O¼F®`¡AÁÂÁ±z¤F!

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD