ªð¦^¦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 : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD